How to get Absence duration for Absence Types with Hours UOM ?

Content

We have leave with UOM hours, we need to get the summation of leaves duration in period

GET_ABSENCE_DAYS_PER_TYPE function is not working correctly with this leave.

I have tried the below formula and it is not getting the correct value

IF mode = 'LATE_IN' THEN

    ( l_abs_duration= 0

       CHANGE_CONTEXTS(HR_ASSIGNMENT_ID = hr_assign_id,EFFECTIVE_DATE = hr_effective_date)

       (

            I = 1

       

            WHILE (ABS_EXT_PER_ABSENCE_ENTRY_ID.EXISTS(I)) LOOP

            (

 

IF ABS_EXT_PER_ABS_TYPE[I]= 'Late'

AND ABS_EXT_PER_ABS_APPROVAL_STATUS_CD[I] = 'APPROVED' 

AND ABS_EXT_PER_ABS_STATUS_CD[I] = 'SUBMITTED' THEN