APPS.PER_NL_LTSR_ARCHIVE dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 332: ,per_absence_attendance_types paat

328: ,per_assignment_status_types past
329: ,per_all_people_f pap
330: ,per_org_structure_versions posv
331: ,per_absence_attendances pab
332: ,per_absence_attendance_types paat
333: WHERE posv.organization_structure_id = c_org_struct_id
334: AND posv.date_from <= c_start_date
335: AND nvl (posv.date_to
336: ,hr_general.end_of_time) >= c_end_date

Line 379: ,per_absence_attendance_types paat

375: FROM per_all_assignments_f paa
376: ,per_all_people_f pap
377: ,per_org_structure_versions posv
378: ,per_absence_attendances pab
379: ,per_absence_attendance_types paat
380: WHERE posv.organization_structure_id = c_org_struct_id
381: AND posv.date_from <= c_start_date
382: AND nvl (posv.date_to
383: ,hr_general.end_of_time) >= c_end_date

Line 750: FROM per_absence_attendance_types paat

746: ,p_start_date IN DATE
747: ,p_end_date IN DATE) is
748: SELECT DISTINCT
749: paa.assignment_id assignment_id
750: FROM per_absence_attendance_types paat
751: ,per_absence_attendances pab
752: ,pay_payroll_actions ppa
753: ,per_all_assignments_f paa
754: ,per_all_people_f pap

Line 783: FROM per_absence_attendance_types paat

779: ,p_start_date IN DATE
780: ,p_end_date IN DATE) IS
781: SELECT DISTINCT
782: paa.assignment_id assignment_id
783: FROM per_absence_attendance_types paat
784: ,per_absence_attendances pab
785: ,pay_payroll_actions ppa
786: ,per_org_structure_versions posv
787: ,per_all_assignments_f paa

Line 837: FROM per_absence_attendance_types paat

833: ,p_end_date IN DATE) IS
834:
835: SELECT DISTINCT
836: paa.assignment_id assignment_id
837: FROM per_absence_attendance_types paat
838: ,per_absence_attendances pab
839: ,per_all_assignments_f paa
840: ,per_all_people_f pap
841: ,pay_payroll_actions ppa

Line 1210: FROM per_absence_attendance_types paat

1206: , pab.abs_information5 est_name
1207: , pab.abs_information6 gender
1208: , pab.abs_information7 tel_no
1209: , pab.abs_information_category info_cat
1210: FROM per_absence_attendance_types paat
1211: , per_absence_attendances pab
1212: , pay_assignment_actions paa
1213: , per_all_assignments_f pas
1214: WHERE paat.absence_category = 'S'