GET_BAL_COMP_VAL
This formula function would return the sum of accrual entries of a particular type within a period.
Mandatory Contexts
- PERSON_ID
- HR_ASSIGNMENT_ID
- EFFECTIVE_DATE
- LEGISLATIVE_DATA_GROUP_ID
Parameters
| Parameter name | Data Type | Description |
|---|---|---|
| p_pl_name | Character | Name of accrual plan |
| p_start_date | Date | Start date of period for when accrual entry amounts are required |
| p_end_date | Date | End date of period for which accrual entry amounts are required |
| p_type | Character | The accrual entry type for which information is required |
| p_adj_reason | Character | If information is required for ‘adjustment’ type then a specific adjustment reason can also be specified |
Data Returned
The sum accrual entries of the particular type between within the period.