GET_PLAN_BALANCE

This formula function can be used to return the accrual balance of an absence plan calculated up until the latest ‘Last Balance Calculation Date’ which is lesser than or earlier than effective date.

Mandatory Contexts

• HR_ASSIGNMENT_ID
• PERSON_ID
• EFFECTIVE_DATE
• LEGISLATIVE_DATA_GROUP

Parameters

Parameter name	Data Type	Description
p_pl_name	Character	Name of accrual plan

Data Returned

The accrual balance in Number format.