DBA Data[Home] [Help]

APPS.HRI_OPL_UTL_ABSNC_DIM dependencies on PER_ALL_ASSIGNMENTS_F

Line 315: ,per_all_assignments_f asg

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
319: AND paa.absence_attendance_id = eq.absence_attendance_id

Line 504: ,per_all_assignments_f asg

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 (+)
508: AND paa.person_id = asg.person_id