Fetching absence hours in timecard inside fast formula

Summary

Fetching absence hours in timecard inside fast formula

Content

Hi All

We have a requirement to calculate accruals inside absence accrual matrix fast formula by considering the total time card hours. 

if an employee has only regular hours, then I am using the below approach to fetch the regular hours

CHANGE_CONTEXTS(HR_ASSIGNMENT_ID = l_ASG_ID,GRP_TYPE_ID = l_grp_type_id, START_DATE = l_Accrual_Period_Start_Date, APPROVED = l_approved)

(

l_status=ESS_LOG_WRITE('NB_l_ASG_ID'+TO_CHAR(l_ASG_ID))

l_wrk_hrs = TL_REG_HOURS_DEFINITION_WORK_HOURS_ASSIGNMENT_ASG_AAP