APPS.PER_NL_DSRR_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 753: FROM per_absence_attendance_types paat

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

Line 787: FROM per_absence_attendance_types paat

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

Line 842: FROM per_absence_attendance_types paat

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

Line 1222: FROM per_absence_attendance_types paat

1218: ,'YYYYMMDD') full_rec_dt
1219: ,to_char (fnd_date.canonical_to_date (pab.abs_information18)
1220: ,'YYYYMMDD') partial_rec_dt
1221: ,pab.abs_information13 daily_si
1222: FROM per_absence_attendance_types paat
1223: ,per_absence_attendances pab
1224: ,pay_assignment_actions paa
1225: ,per_all_assignments_f pas
1226: WHERE paat.absence_category = 'S'