APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on PER_ALL_PEOPLE_F

Line 998: per_all_people_f pap,

994: pap.national_identifier,
995: pap.sex,
996: pap.date_of_birth
997: FROM per_all_assignments_f paa,
998: per_all_people_f pap,
999: per_periods_of_service pps,
1000: pay_all_payrolls_f pay,
1001: hr_soft_coding_keyflex flex
1002: WHERE paa.person_id = pap.person_id

Line 2656: per_all_people_f ppf,

2652:
2653: cursor csr_ni is
2654: select ppf.national_identifier
2655: from per_assignments_f paf,
2656: per_all_people_f ppf,
2657: per_periods_of_service pps
2658: where ppf.person_id = paf.person_id
2659: and paf.assignment_id = p_assid
2660: and paf.period_of_service_id = pps.period_of_service_id(+)

Line 2766: per_all_people_f p,

2762: p1.first_name,
2763: p1.last_name,
2764: p1.middle_names
2765: from per_all_assignments_f a,
2766: per_all_people_f p,
2767: per_all_people_f p1
2768: where a.assignment_id = p_assignment_id
2769: and p.person_id = a.person_id
2770: and p1.person_id = a.person_id

Line 2767: per_all_people_f p1

2763: p1.last_name,
2764: p1.middle_names
2765: from per_all_assignments_f a,
2766: per_all_people_f p,
2767: per_all_people_f p1
2768: where a.assignment_id = p_assignment_id
2769: and p.person_id = a.person_id
2770: and p1.person_id = a.person_id
2771: and p_asg_end_date between p.effective_start_date and p.effective_end_date

Line 2817: l_fu_name per_all_people_f.full_name%type;

2813: nvl(a.action_information11,' ')<> nvl(a1.region_3,' ') or
2814: nvl(a.action_information12,' ')<> nvl(a1.postal_code,' ') or
2815: nvl(a.action_information13,' ')<> nvl(a1.country,' '));
2816:
2817: l_fu_name per_all_people_f.full_name%type;
2818: l_fi_name per_all_people_f.first_name%type;
2819: l_l_name per_all_people_f.last_name%type;
2820: l_m_names per_all_people_f.middle_names%type;
2821: l_addr1 per_addresses.address_line1%type;

Line 2818: l_fi_name per_all_people_f.first_name%type;

2814: nvl(a.action_information12,' ')<> nvl(a1.postal_code,' ') or
2815: nvl(a.action_information13,' ')<> nvl(a1.country,' '));
2816:
2817: l_fu_name per_all_people_f.full_name%type;
2818: l_fi_name per_all_people_f.first_name%type;
2819: l_l_name per_all_people_f.last_name%type;
2820: l_m_names per_all_people_f.middle_names%type;
2821: l_addr1 per_addresses.address_line1%type;
2822: l_addr2 per_addresses.address_line2%type;

Line 2819: l_l_name per_all_people_f.last_name%type;

2815: nvl(a.action_information13,' ')<> nvl(a1.country,' '));
2816:
2817: l_fu_name per_all_people_f.full_name%type;
2818: l_fi_name per_all_people_f.first_name%type;
2819: l_l_name per_all_people_f.last_name%type;
2820: l_m_names per_all_people_f.middle_names%type;
2821: l_addr1 per_addresses.address_line1%type;
2822: l_addr2 per_addresses.address_line2%type;
2823: l_addr3 per_addresses.address_line3%type;

Line 2820: l_m_names per_all_people_f.middle_names%type;

2816:
2817: l_fu_name per_all_people_f.full_name%type;
2818: l_fi_name per_all_people_f.first_name%type;
2819: l_l_name per_all_people_f.last_name%type;
2820: l_m_names per_all_people_f.middle_names%type;
2821: l_addr1 per_addresses.address_line1%type;
2822: l_addr2 per_addresses.address_line2%type;
2823: l_addr3 per_addresses.address_line3%type;
2824: l_toc per_addresses.town_or_city%type;

Line 4333: per_all_people_f pap,

4329: pml.line_sequence
4330: from pay_payroll_actions pay,
4331: pay_assignment_actions paa,
4332: per_all_assignments_f paf,
4333: per_all_people_f pap,
4334: per_periods_of_service pos,
4335: pay_message_lines pml
4336: where pay.payroll_action_id = p_pact_id
4337: and paa.payroll_action_id = pay.payroll_action_id