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_ALL_PEOPLE_F

Line 463: ,per_all_people_f pap

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

Line 510: ,per_all_people_f pap

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

Line 783: FROM per_all_people_f pap

779: ,sqlstr OUT NOCOPY VARCHAR2) is
780: BEGIN
781: hr_utility.trace('+====range_code============================================+');
782: sqlstr := 'SELECT DISTINCT person_id
783: FROM per_all_people_f pap
784: ,pay_payroll_actions ppa
785: WHERE ppa.payroll_action_id = :payroll_action_id
786: AND ppa.business_group_id = pap.business_group_id
787: ORDER BY pap.person_id';

Line 889: ,per_all_people_f pap

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'
891: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
892: AND paat.business_group_id = pab.business_group_id
893: AND pab.date_start BETWEEN p_start_date

Line 923: ,per_all_people_f pap

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
924: WHERE posv.organization_structure_id = p_org_struct_id
925: AND posv.date_from <= p_end_date
926: AND nvl (posv.date_to,hr_general.end_of_time) >= p_start_date
927: AND (

Line 975: ,per_all_people_f pap

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

Line 1027: ,per_all_people_f pap

1023: paa.assignment_id assignment_id
1024: FROM pay_action_information pai
1025: ,pay_payroll_actions ppa
1026: ,per_all_assignments_f paa
1027: ,per_all_people_f pap
1028: WHERE pai.action_context_type = 'AAP'
1029: AND pai.action_information_category = 'NL_DSR_ABS_INFO'
1030: AND pai.action_information4 = 'SR'
1031: AND pai.action_information29 = 'NL_SR'

Line 1069: ,per_all_people_f pap

1065: FROM pay_action_information pai
1066: ,pay_payroll_actions ppa
1067: ,per_org_structure_versions posv
1068: ,per_all_assignments_f paa
1069: ,per_all_people_f pap
1070: WHERE posv.organization_structure_id = p_org_struct_id
1071: AND posv.date_from <= p_end_date
1072: AND nvl (posv.date_to
1073: ,hr_general.end_of_time) >= p_start_date

Line 1128: ,per_all_people_f pap

1124: SELECT DISTINCT
1125: paa.assignment_id assignment_id
1126: FROM pay_action_information pai
1127: ,per_all_assignments_f paa
1128: ,per_all_people_f pap
1129: ,pay_payroll_actions ppa
1130: ,per_org_structure_versions posv
1131: WHERE posv.organization_structure_id = p_org_struct_id
1132: AND pap.person_id BETWEEN p_start_person_id

Line 1478: FROM per_all_people_f pap

1474: ,pap.employee_number employee_number
1475: ,pap.person_id person_id
1476: ,pap.business_group_id bg_id
1477: ,pas.establishment_id establishment_id
1478: FROM per_all_people_f pap
1479: ,per_all_assignments_f pas
1480: WHERE pas.assignment_id = p_assignment_id
1481: AND p_start_date BETWEEN pas.effective_start_date
1482: AND pas.effective_end_date

Line 1582: AND pp.parent_table = 'PER_ALL_PEOPLE_F'

1578: WHERE pas.assignment_id = p_assignment_id
1579: AND p_start_date BETWEEN pas.effective_start_date
1580: AND pas.effective_end_date
1581: AND pas.person_id = pp.parent_id
1582: AND pp.parent_table = 'PER_ALL_PEOPLE_F'
1583: AND pp.phone_type = p_type
1584: AND p_start_date BETWEEN pp.date_from
1585: AND nvl (pp.date_to
1586: ,hr_general.end_of_time);

Line 2276: FROM per_all_people_f

2272: WHERE organization_id = p_org_id;
2273:
2274: CURSOR c_get_employee(p_person_id IN NUMBER) IS
2275: SELECT full_name
2276: FROM per_all_people_f
2277: WHERE person_id = p_person_id;
2278:
2279: BEGIN
2280: hr_utility.trace('+====gen_header_xml========================================+');