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_ATTENDANCES

Line 465: ,per_absence_attendances pab

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

Line 512: ,per_absence_attendances pab

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

Line 886: ,per_absence_attendances pab

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

Line 919: ,per_absence_attendances pab

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

Line 973: ,per_absence_attendances pab

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

Line 1366: ,per_absence_attendances pab

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

Line 1695: FROM per_absence_attendances

1691: FROM (
1692: SELECT absence_attendance_id
1693: ,nvl(fnd_date.canonical_to_date(abs_information9),date_start) date_start
1694: ,date_end
1695: FROM per_absence_attendances
1696: START WITH absence_attendance_id = c_current_absence
1697: CONNECT BY PRIOR abs_information27 = absence_attendance_id
1698: )
1699: WHERE absence_attendance_id <> c_current_absence

Line 1705: FROM per_absence_attendances

1701: AND date_end IS NOT NULL
1702: AND date_end <
1703: (
1704: SELECT nvl(fnd_date.canonical_to_date(abs_information9),date_start) date_start
1705: FROM per_absence_attendances
1706: WHERE absence_attendance_id = c_current_absence
1707: );
1708: /**************************************************************************/
1709: CURSOR c_get_pact_chunk(c_assignment_action_id IN NUMBER ) IS

Line 2515: WHERE fad.entity_name = 'PER_ABSENCE_ATTENDANCES'

2511: ,fnd_documents fd
2512: ,fnd_document_categories fdc
2513: ,fnd_document_datatypes fdd
2514: ,fnd_documents_short_text fdst
2515: WHERE fad.entity_name = 'PER_ABSENCE_ATTENDANCES'
2516: AND fad.pk1_value = to_char(p_abs_attendance_id)
2517: AND fd.document_id = fad.document_id
2518: AND fdd.datatype_id = fd.datatype_id
2519: AND fdc.category_id = fd.category_id