eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_NL_LTSR_ARCHIVE dependencies on PER_ABSENCE_ATTENDANCES

Line 331: ,per_absence_attendances pab

327: FROM per_all_assignments_f paa
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

Line 378: ,per_absence_attendances pab

374: SELECT 1
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

Line 751: ,per_absence_attendances pab

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
755: WHERE paat.absence_category = 'S'

Line 784: ,per_absence_attendances pab

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
788: ,per_all_people_f pap

Line 838: ,per_absence_attendances pab

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
842: ,per_org_structure_versions posv

Line 1211: , per_absence_attendances pab

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'
1215: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id