I used the GET_NET_ACCRUAL function, but always I received zero amount as a result
Summary:
I used the GET_NET_ACCRUAL function with the related parameters in the same sequence, but always I received zero amount as a result, for more details, please see my code sample and screenshots below:
l_PAYROLL_id = GET_CONTEXT(PAYROLL_TERM_ID, 0)
l_asg_hr_asg_id = ASG_HR_ASG_ID
L_PERSON_ID = GET_CONTEXT(PERSON_ID,0)
ln_paid_vacation_plan_id = 300000003774908 /*Accrual Plan Id for "Annual Leave Plan" */
ACCRUAL_PLAN_ID = ln_paid_vacation_plan_id
/*l_asg_hr_asg_id = GET_CONTEXT(HR_ASSIGNMENT_ID,0)*/
L_Leave_Balance = GET_NET_ACCRUAL(ACCRUAL_PLAN_ID, l_date, l_actual_end_date, 0)