How to to get the total time for Elapsed shift in Global Absence Type Duration Fast Formula

Content

We have one requirement where we need to write some conversion Fast Formula (Global Absence Type Duration). I am able to create this formula by using GET_PAY_AVAILABILITY function but this function is only working fine for Time Type Work Schedule. Below is the code which I am using.

ld_period_start_date = to_date(to_char(IV_START_DATE,'DD/MM/RRRR')||' '||IV_START_TIME,'DD/MM/RRRR HH24:MI:SS')
ld_period_end_date = to_date(to_char(IV_START_DATE,'DD/MM/RRRR')||' '||IV_END_TIME,'DD/MM/RRRR HH24:MI:SS')