DBA Data[Home] [Help]

APPS.HRI_OPL_UTL_ABSNC_DIM dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 313: ,per_absence_attendance_types pat

309: ,g_user
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

Line 502: ,per_absence_attendance_types pat

498: ,paa.time_start
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