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_DSR_ARCHIVE dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 466: ,per_absence_attendance_types paat

462: ,per_assignment_status_types past
463: ,per_all_people_f pap
464: ,per_org_structure_versions posv
465: ,per_absence_attendances pab
466: ,per_absence_attendance_types paat
467: WHERE posv.organization_structure_id = c_org_struct_id
468: AND posv.date_from <= c_start_date
469: AND nvl (posv.date_to
470: ,hr_general.end_of_time) >= c_end_date

Line 513: ,per_absence_attendance_types paat

509: FROM per_all_assignments_f paa
510: ,per_all_people_f pap
511: ,per_org_structure_versions posv
512: ,per_absence_attendances pab
513: ,per_absence_attendance_types paat
514: WHERE posv.organization_structure_id = c_org_struct_id
515: AND posv.date_from <= c_start_date
516: AND nvl (posv.date_to
517: ,hr_general.end_of_time) >= c_end_date

Line 885: FROM per_absence_attendance_types paat

881: ,p_start_date IN DATE
882: ,p_end_date IN DATE) is
883: SELECT DISTINCT
884: paa.assignment_id assignment_id
885: FROM per_absence_attendance_types paat
886: ,per_absence_attendances pab
887: ,pay_payroll_actions ppa
888: ,per_all_assignments_f paa
889: ,per_all_people_f pap

Line 918: FROM per_absence_attendance_types paat

914: ,p_start_date IN DATE
915: ,p_end_date IN DATE) IS
916: SELECT DISTINCT
917: paa.assignment_id assignment_id
918: FROM per_absence_attendance_types paat
919: ,per_absence_attendances pab
920: ,pay_payroll_actions ppa
921: ,per_org_structure_versions posv
922: ,per_all_assignments_f paa

Line 972: FROM per_absence_attendance_types paat

968: ,p_end_date IN DATE) IS
969:
970: SELECT DISTINCT
971: paa.assignment_id assignment_id
972: FROM per_absence_attendance_types paat
973: ,per_absence_attendances pab
974: ,per_all_assignments_f paa
975: ,per_all_people_f pap
976: ,pay_payroll_actions ppa

Line 1365: FROM per_absence_attendance_types paat

1361: ,decode (pab.abs_information23,'Y','1','N','2') period_less_three
1362: ,pab.abs_information24 no_of_first_call
1363: ,decode (pab.abs_information25,'Y','1','N','2') work_long_all
1364: ,pab.abs_information26 temp_cont
1365: FROM per_absence_attendance_types paat
1366: ,per_absence_attendances pab
1367: ,pay_assignment_actions paa
1368: ,per_all_assignments_f pas
1369: WHERE paat.absence_category = 'S'