APPS.PER_NL_FDR_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 302: from per_all_people_f pap

298:
299: BEGIN
300:
301: select distinct pap.effective_start_date into l_ref_date
302: from per_all_people_f pap
303: where pap.person_id = p_person_id
304: and pap.effective_start_date =
305: (select max(pap1.effective_start_date)
306: from per_all_people_f pap1

Line 306: from per_all_people_f pap1

302: from per_all_people_f pap
303: where pap.person_id = p_person_id
304: and pap.effective_start_date =
305: (select max(pap1.effective_start_date)
306: from per_all_people_f pap1
307: where pap1.person_id = p_person_id
308: and pap1.current_employee_flag = 'Y')
309: and exists (select 1 from per_people_extra_info ppei
310: where ppei.person_id=p_person_id

Line 352: per_all_people_f pap,

348:
349: select 1 INTO l_return_val
350: from per_all_assignments_f paa,
351: per_assignment_status_types past,
352: per_all_people_f pap,
353: per_periods_of_service ppos,
354: per_org_structure_versions posv
355:
356: where posv.organization_structure_id=p_org_struct_id

Line 410: per_all_people_f pap,

406:
407: select 1 INTO l_return_val
408: from per_all_assignments_f paa,
409: per_assignment_status_types past,
410: per_all_people_f pap,
411: per_periods_of_service ppos,
412: per_org_structure_versions posv
413:
414: where posv.organization_structure_id=p_org_struct_id

Line 631: FROM per_all_people_f pap

627: BEGIN
628:
629:
630: sqlstr := 'SELECT DISTINCT person_id
631: FROM per_all_people_f pap
632: ,pay_payroll_actions ppa
633: WHERE ppa.payroll_action_id = :payroll_action_id
634: AND ppa.business_group_id = pap.business_group_id
635: ORDER BY pap.person_id';

Line 677: per_all_people_f pap,

673:
674: from per_all_assignments_f paa,
675: per_assignment_status_types past,
676: pay_payroll_actions ppa,
677: per_all_people_f pap,
678: per_periods_of_service ppos
679:
680: where p_person_id between p_start_person_id and p_end_person_id
681: and pap.person_id = p_person_id

Line 720: per_all_people_f pap,

716: select distinct paa.assignment_id assignment_id
717:
718: from per_all_assignments_f paa,
719: per_assignment_status_types past,
720: per_all_people_f pap,
721: pay_payroll_actions ppa,
722: per_periods_of_service ppos,
723: per_org_structure_versions posv
724:

Line 777: per_all_people_f pap,

773: select distinct paa.assignment_id assignment_id
774:
775: from per_all_assignments_f paa,
776: per_assignment_status_types past,
777: per_all_people_f pap,
778: pay_payroll_actions ppa,
779: per_periods_of_service ppos,
780: per_org_structure_versions posv
781:

Line 986: from per_all_people_f pap,

982: pap.person_id person_id,
983: pap.business_group_id bg_id,
984: pas.establishment_id establishment_id
985:
986: from per_all_people_f pap,
987: per_all_assignments_f pas,
988: per_assignment_status_types past,
989: pay_assignment_actions paa,
990: per_periods_of_service ppos

Line 1001: from per_all_people_f pap1

997: and past.per_system_status = 'ACTIVE_ASSIGN'
998: and get_ref_date(pap.person_id) between pas.effective_start_date and pas.effective_end_date
999: and pap.effective_start_date =
1000: (select max(pap1.effective_start_date)
1001: from per_all_people_f pap1
1002: where pap.person_id = pap1.person_id)
1003: and ppos.person_id = pap.person_id
1004: and ppos.date_start =
1005: (select max(date_start)

Line 1026: l_employee_number per_all_people_f.employee_number%TYPE;

1022: l_bg_id NUMBER;
1023: l_msg_id VARCHAR2(100);
1024: l_tax_reg_num VARCHAR2(100);
1025: l_hire_date DATE;
1026: l_employee_number per_all_people_f.employee_number%TYPE;
1027: l_sofi_number VARCHAR2(30) := null;
1028: l_initial VARCHAR2(150);
1029: l_prefix VARCHAR2(30);
1030: l_last_name VARCHAR2(150);

Line 1312: per_all_people_f pap,

1308: pap.full_name name
1309:
1310: from per_all_assignments_f paa,
1311: per_assignment_status_types past,
1312: per_all_people_f pap,
1313: pay_payroll_actions ppa,
1314: per_periods_of_service ppos,
1315: per_org_structure_versions posv
1316: