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*/
Tagged:
0