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_ALL_PEOPLE_F

Line 333: ,per_all_people_f pap

329: ,c_end_date IN DATE) IS
330: SELECT 1
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

Line 379: ,per_all_people_f pap

375: ,c_start_date IN DATE
376: ,c_end_date IN DATE) IS
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

Line 651: FROM per_all_people_f pap

647: ,sqlstr OUT NOCOPY VARCHAR2) is
648: BEGIN
649: hr_utility.trace('+====range_code============================================+');
650: sqlstr := 'SELECT DISTINCT person_id
651: FROM per_all_people_f pap
652: ,pay_payroll_actions ppa
653: WHERE ppa.payroll_action_id = :payroll_action_id
654: AND ppa.business_group_id = pap.business_group_id
655: ORDER BY pap.person_id';

Line 757: ,per_all_people_f pap

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'
759: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
760: AND paat.business_group_id = pab.business_group_id
761: AND pab.date_start BETWEEN p_start_date

Line 790: ,per_all_people_f pap

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
791: WHERE posv.organization_structure_id = p_org_struct_id
792: AND posv.date_from <= p_end_date
793: AND nvl (posv.date_to,hr_general.end_of_time) >= p_start_date
794: AND (

Line 841: ,per_all_people_f pap

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
844: WHERE posv.organization_structure_id = p_org_struct_id
845: AND pap.person_id BETWEEN p_start_person_id

Line 892: ,per_all_people_f pap

888: paa.assignment_id assignment_id
889: FROM pay_action_information pai
890: ,pay_payroll_actions ppa
891: ,per_all_assignments_f paa
892: ,per_all_people_f pap
893: WHERE pai.action_context_type = 'AAP'
894: AND pai.action_information_category = 'NL_WAZO_ABS_INFO'
895: AND pai.action_information4 = 'WAZO'
896: AND pai.action_information29 = 'NL_WAZO'

Line 934: ,per_all_people_f pap

930: FROM pay_action_information pai
931: ,pay_payroll_actions ppa
932: ,per_org_structure_versions posv
933: ,per_all_assignments_f paa
934: ,per_all_people_f pap
935: WHERE posv.organization_structure_id = p_org_struct_id
936: AND posv.date_from <= p_end_date
937: AND nvl (posv.date_to
938: ,hr_general.end_of_time) >= p_start_date

Line 993: ,per_all_people_f pap

989: SELECT DISTINCT
990: paa.assignment_id assignment_id
991: FROM pay_action_information pai
992: ,per_all_assignments_f paa
993: ,per_all_people_f pap
994: ,pay_payroll_actions ppa
995: ,per_org_structure_versions posv
996: WHERE posv.organization_structure_id = p_org_struct_id
997: AND pap.person_id BETWEEN p_start_person_id

Line 1323: FROM per_all_people_f pap

1319: ,pap.employee_number employee_number
1320: ,pap.person_id person_id
1321: ,pap.business_group_id bg_id
1322: ,pas.establishment_id establishment_id
1323: FROM per_all_people_f pap
1324: ,per_all_assignments_f pas
1325: WHERE pas.assignment_id = p_assignment_id
1326: AND p_start_date BETWEEN pas.effective_start_date
1327: AND pas.effective_end_date

Line 1383: AND pp.parent_table = 'PER_ALL_PEOPLE_F'

1379: WHERE pas.assignment_id = p_assignment_id
1380: AND p_start_date BETWEEN pas.effective_start_date
1381: AND pas.effective_end_date
1382: AND pas.person_id = pp.parent_id
1383: AND pp.parent_table = 'PER_ALL_PEOPLE_F'
1384: AND pp.phone_type = p_type
1385: AND p_start_date BETWEEN pp.date_from
1386: AND nvl (pp.date_to
1387: ,hr_general.end_of_time);

Line 1910: FROM per_all_people_f

1906: WHERE organization_id = p_org_id;
1907:
1908: CURSOR c_get_employee(p_person_id IN NUMBER) IS
1909: SELECT full_name
1910: FROM per_all_people_f
1911: WHERE person_id = p_person_id;
1912:
1913: BEGIN
1914: hr_utility.trace('+====gen_header_xml========================================+');