Get Absence Balance in worksheet

Summary:

We wanted to get the employees Absence Balance in worksheet in User Table column

Content (required):

We are trying to get the employees balance with below FF of type - Compensation Default and Override formula but it is not working

DEFAULT FOR ORA_RAEP_TRE_LAST_UPDATE_DATE IS '0001/01/01 00:00:00' (DATE)

L_MSG = 'XX'

L_VALUE = 0

DAYS = 0

accrual_bal = 0

L_DEFAULT_VALUE = 0

l_hr_assignment_id = ASG_HR_ASG_ID

l_effective_date= GET_CONTEXT(END_DATE,ORA_RAEP_TRE_LAST_UPDATE_DATE) /* If you want to get accrual balance base on another date, you can change the effective date*/