APPS.PER_NL_WAZO_ARCHIVE dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 336: ,per_absence_attendance_types paat

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

Line 382: ,per_absence_attendance_types paat

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

Line 753: FROM per_absence_attendance_types paat

749: ,p_start_date IN DATE
750: ,p_end_date IN DATE) is
751: SELECT DISTINCT
752: paa.assignment_id assignment_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 785: FROM per_absence_attendance_types paat

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

Line 838: FROM per_absence_attendance_types paat

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

Line 1212: FROM per_absence_attendance_types paat

1208: ,pab.abs_information4 reason
1209: ,decode (pab.abs_information5,'Y','1','N','2') spl_sit
1210: ,to_char (fnd_date.canonical_to_date(pab.abs_information6),'YYYYMMDD') est_dob
1211: ,to_char (pab.date_start,'YYYYMMDD') wazo_st_dt
1212: FROM per_absence_attendance_types paat
1213: ,per_absence_attendances pab
1214: ,pay_assignment_actions paa
1215: ,per_all_assignments_f pas
1216: WHERE paat.absence_category = 'WAZO'