DBA Data[Home] [Help]

APPS.HRI_OPL_UTL_ABSNC_DIM dependencies on PER_ABS_ATTENDANCE_REASONS

Line 314: ,per_abs_attendance_reasons par

310: ,g_sysdate
311: FROM
312: per_absence_attendances paa
313: ,per_absence_attendance_types pat
314: ,per_abs_attendance_reasons par
315: ,per_all_assignments_f asg
316: ,hri_eq_utl_absnc_dim eq
317: WHERE eq.absence_attendance_id BETWEEN p_start_abs_id
318: AND p_end_abs_id

Line 503: ,per_abs_attendance_reasons par

499: ,paa.time_end)) abs_drtn_hrs
500: FROM
501: per_absence_attendances paa
502: ,per_absence_attendance_types pat
503: ,per_abs_attendance_reasons par
504: ,per_all_assignments_f asg
505: WHERE paa.person_id = p_person_id
506: AND paa.absence_attendance_type_id = pat.absence_attendance_type_id
507: AND paa.abs_attendance_reason_id = par.abs_attendance_reason_id (+)