GET_BAL_HDR_VAL
This formula function fetches summary level accrual information for the first accrual period after effective date for which accrual has been run.
Mandatory Contexts
- PERSON_ID
- HR_ASSIGNMENT_ID
- EFFECTIVE_DATE
- LEGISLATIVE_DATA_GROUP_ID
Parameters
| Parameter name | Data Type | Description |
|---|---|---|
| p_pl_name | Character | The name of the accrual plan for which accrual and balance information is required |
| p_begin_bal | Number | Out parameter - The accrual balance at the start of the repeating period |
| p_accrued | Number | Out parameter - The amount of time accrued in the repeating period |
| p_used | Number | Out parameter - The amount of time used during the repeating period |
| p_end_bal | Number | Out parameter - The final balance as of the end of the repeating period |
| p_accrual_period | Date | Out parameter - The effective date of the repeating period |
Data Returned
The function returns a value ‘1’ if data is found and ‘0’ if no data is found.