APPS.PER_NL_LTSRR_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 755: FROM per_absence_attendance_types paat

751: ,p_end_date IN DATE) IS
752: SELECT DISTINCT
753: paa.assignment_id assignment_id
754: , pab.absence_attendance_id abs_att_id
755: FROM per_absence_attendance_types paat
756: , per_absence_attendances pab
757: , pay_payroll_actions ppa
758: , per_all_assignments_f paa
759: , per_all_people_f pap

Line 789: FROM per_absence_attendance_types paat

785: ,p_end_date IN DATE) IS
786: SELECT DISTINCT
787: paa.assignment_id assignment_id
788: , pab.absence_attendance_id abs_att_id
789: FROM per_absence_attendance_types paat
790: , per_absence_attendances pab
791: , pay_payroll_actions ppa
792: , per_org_structure_versions posv
793: , per_all_assignments_f paa

Line 844: FROM per_absence_attendance_types paat

840:
841: SELECT DISTINCT
842: paa.assignment_id assignment_id
843: , pab.absence_attendance_id abs_att_id
844: FROM per_absence_attendance_types paat
845: , per_absence_attendances pab
846: , per_all_assignments_f paa
847: , per_all_people_f pap
848: , pay_payroll_actions ppa

Line 1217: FROM per_absence_attendance_types paat

1213: , pab.abs_information6 sick_ref
1214: , to_char (pab.date_start, 'YYYYMMDD') lts_st_dt
1215: , to_char ((pab.date_end + 1), 'YYYYMMDD') lts_rec_dt
1216: , pab.abs_information_category info_cat
1217: FROM per_absence_attendance_types paat
1218: , per_absence_attendances pab
1219: , pay_assignment_actions paa
1220: , per_all_assignments_f pas
1221: WHERE paat.absence_category = 'S'