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_LTSRR_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 756: , per_absence_attendances pab

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

Line 790: , per_absence_attendances pab

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

Line 845: , per_absence_attendances pab

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

Line 1218: , per_absence_attendances pab

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