DBA Data[Home] [Help]

APPS.HRI_OPL_UTL_ABSNC_DIM dependencies on HRI_BPL_UTILIZATION

Line 282: ,SUM(hri_bpl_utilization.calculate_absence_duration

278: ELSE 'OCCURRED'
279: END absence_status_code
280: ,paa.absence_attendance_type_id
281: ,NVL(paa.abs_attendance_reason_id, -1) abs_attendance_reason_id
282: ,SUM(hri_bpl_utilization.calculate_absence_duration
283: (paa.absence_attendance_id
284: ,'DAYS'
285: ,paa.absence_hours
286: ,paa.absence_days

Line 294: ,SUM(hri_bpl_utilization.calculate_absence_duration

290: ,paa.date_start
291: ,NVL(paa.date_end, trunc(sysdate))
292: ,paa.time_start
293: ,paa.time_end)) abs_drtn_days
294: ,SUM(hri_bpl_utilization.calculate_absence_duration
295: (paa.absence_attendance_id
296: ,'HOURS'
297: ,paa.absence_hours
298: ,paa.absence_days

Line 476: ,SUM(hri_bpl_utilization.calculate_absence_duration

472: ELSE 'OCCURRED'
473: END absence_status_code
474: ,paa.absence_attendance_type_id
475: ,NVL(paa.abs_attendance_reason_id, -1) abs_attendance_reason_id
476: ,SUM(hri_bpl_utilization.calculate_absence_duration
477: (paa.absence_attendance_id
478: ,'DAYS'
479: ,paa.absence_hours
480: ,paa.absence_days

Line 488: ,SUM(hri_bpl_utilization.calculate_absence_duration

484: ,paa.date_start
485: ,NVL(paa.date_end, trunc(sysdate))
486: ,paa.time_start
487: ,paa.time_end)) abs_drtn_days
488: ,SUM(hri_bpl_utilization.calculate_absence_duration
489: (paa.absence_attendance_id
490: ,'HOURS'
491: ,paa.absence_hours
492: ,paa.absence_days