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_WAZO_ARCHIVE dependencies on PER_ABSENCE_ATTENDANCES

Line 335: ,per_absence_attendances pab

331: FROM per_all_assignments_f paa
332: ,per_assignment_status_types past
333: ,per_all_people_f pap
334: ,per_org_structure_versions posv
335: ,per_absence_attendances pab
336: ,per_absence_attendance_types paat
337: WHERE posv.organization_structure_id = c_org_struct_id
338: AND posv.date_from <= c_start_date
339: AND nvl (posv.date_to

Line 381: ,per_absence_attendances pab

377: SELECT 1
378: FROM per_all_assignments_f paa
379: ,per_all_people_f pap
380: ,per_org_structure_versions posv
381: ,per_absence_attendances pab
382: ,per_absence_attendance_types paat
383: WHERE posv.organization_structure_id = c_org_struct_id
384: AND posv.date_from <= c_start_date
385: AND nvl (posv.date_to

Line 754: ,per_absence_attendances pab

750: ,p_end_date IN DATE) is
751: SELECT DISTINCT
752: paa.assignment_id assignment_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 = 'WAZO'

Line 786: ,per_absence_attendances pab

782: ,p_end_date IN DATE) IS
783: SELECT DISTINCT
784: paa.assignment_id assignment_id
785: FROM per_absence_attendance_types paat
786: ,per_absence_attendances pab
787: ,pay_payroll_actions ppa
788: ,per_org_structure_versions posv
789: ,per_all_assignments_f paa
790: ,per_all_people_f pap

Line 839: ,per_absence_attendances pab

835:
836: SELECT DISTINCT
837: paa.assignment_id assignment_id
838: FROM per_absence_attendance_types paat
839: ,per_absence_attendances pab
840: ,per_all_assignments_f paa
841: ,per_all_people_f pap
842: ,pay_payroll_actions ppa
843: ,per_org_structure_versions posv

Line 1213: ,per_absence_attendances pab

1209: ,decode (pab.abs_information5,'Y','1','N','2') spl_sit
1210: ,to_char (fnd_date.canonical_to_date(pab.abs_information6),'YYYYMMDD') est_dob
1211: ,to_char (pab.date_start,'YYYYMMDD') wazo_st_dt
1212: FROM per_absence_attendance_types paat
1213: ,per_absence_attendances pab
1214: ,pay_assignment_actions paa
1215: ,per_all_assignments_f pas
1216: WHERE paat.absence_category = 'WAZO'
1217: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id

Line 2078: WHERE fad.entity_name = 'PER_ABSENCE_ATTENDANCES'

2074: ,fnd_documents fd
2075: ,fnd_document_categories fdc
2076: ,fnd_document_datatypes fdd
2077: ,fnd_documents_short_text fdst
2078: WHERE fad.entity_name = 'PER_ABSENCE_ATTENDANCES'
2079: AND fad.pk1_value = to_char (p_abs_attendance_id)
2080: AND fd.document_id = fad.document_id
2081: AND fdd.datatype_id = fd.datatype_id
2082: AND fdc.category_id = fd.category_id