How to get the persons total working days by using IV_START_DATE AND IV_END_DATE
Summary:
Content (please ensure you mask any confidential information):
l_period_start_date = to_date(to_char(IV_START_DATE,'DD/MM/RRRR')||' '||IV_START_TIME,'DD/MM/RRRR HH24:MI:SS')
l_period_end_date = to_date(to_char(IV_END_DATE,'DD/MM/RRRR')||' '||IV_END_TIME,'DD/MM/RRRR HH24:MI:SS')
/*
l_entry_duration = GET_PAY_AVAILABILITY ('ASSIGN',
l_period_start_date,
l_period_end_date,
'Y',
'Y',
'Y',
'Y',
'D')
*/
CALL_FORMULA( 'GET_PAY_AVAILABILITY',
l_period_start_date > 'actual_start_date',
l_period_end_date > 'actual_end_date',
'D' > 'unit_type',