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_DSRR_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 754: , per_absence_attendances pab

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

Line 788: , per_absence_attendances pab

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

Line 843: , per_absence_attendances pab

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

Line 1223: ,per_absence_attendances pab

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