APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on PER_ALL_PEOPLE_F

Line 997: per_all_people_f pap,

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

Line 2590: per_all_people_f ppf,

2586:
2587: cursor csr_ni is
2588: select ppf.national_identifier
2589: from per_assignments_f paf,
2590: per_all_people_f ppf,
2591: per_periods_of_service pps
2592: where ppf.person_id = paf.person_id
2593: and paf.assignment_id = p_assid
2594: and paf.period_of_service_id = pps.period_of_service_id(+)

Line 2700: per_all_people_f p,

2696: p1.first_name,
2697: p1.last_name,
2698: p1.middle_names
2699: from per_all_assignments_f a,
2700: per_all_people_f p,
2701: per_all_people_f p1
2702: where a.assignment_id = p_assignment_id
2703: and p.person_id = a.person_id
2704: and p1.person_id = a.person_id

Line 2701: per_all_people_f p1

2697: p1.last_name,
2698: p1.middle_names
2699: from per_all_assignments_f a,
2700: per_all_people_f p,
2701: per_all_people_f p1
2702: where a.assignment_id = p_assignment_id
2703: and p.person_id = a.person_id
2704: and p1.person_id = a.person_id
2705: and p_asg_end_date between p.effective_start_date and p.effective_end_date

Line 2751: l_fu_name per_all_people_f.full_name%type;

2747: nvl(a.action_information11,' ')<> nvl(a1.region_3,' ') or
2748: nvl(a.action_information12,' ')<> nvl(a1.postal_code,' ') or
2749: nvl(a.action_information13,' ')<> nvl(a1.country,' '));
2750:
2751: l_fu_name per_all_people_f.full_name%type;
2752: l_fi_name per_all_people_f.first_name%type;
2753: l_l_name per_all_people_f.last_name%type;
2754: l_m_names per_all_people_f.middle_names%type;
2755: l_addr1 per_addresses.address_line1%type;

Line 2752: l_fi_name per_all_people_f.first_name%type;

2748: nvl(a.action_information12,' ')<> nvl(a1.postal_code,' ') or
2749: nvl(a.action_information13,' ')<> nvl(a1.country,' '));
2750:
2751: l_fu_name per_all_people_f.full_name%type;
2752: l_fi_name per_all_people_f.first_name%type;
2753: l_l_name per_all_people_f.last_name%type;
2754: l_m_names per_all_people_f.middle_names%type;
2755: l_addr1 per_addresses.address_line1%type;
2756: l_addr2 per_addresses.address_line2%type;

Line 2753: l_l_name per_all_people_f.last_name%type;

2749: nvl(a.action_information13,' ')<> nvl(a1.country,' '));
2750:
2751: l_fu_name per_all_people_f.full_name%type;
2752: l_fi_name per_all_people_f.first_name%type;
2753: l_l_name per_all_people_f.last_name%type;
2754: l_m_names per_all_people_f.middle_names%type;
2755: l_addr1 per_addresses.address_line1%type;
2756: l_addr2 per_addresses.address_line2%type;
2757: l_addr3 per_addresses.address_line3%type;

Line 2754: l_m_names per_all_people_f.middle_names%type;

2750:
2751: l_fu_name per_all_people_f.full_name%type;
2752: l_fi_name per_all_people_f.first_name%type;
2753: l_l_name per_all_people_f.last_name%type;
2754: l_m_names per_all_people_f.middle_names%type;
2755: l_addr1 per_addresses.address_line1%type;
2756: l_addr2 per_addresses.address_line2%type;
2757: l_addr3 per_addresses.address_line3%type;
2758: l_toc per_addresses.town_or_city%type;

Line 4213: per_all_people_f pap,

4209: pml.line_sequence
4210: from pay_payroll_actions pay,
4211: pay_assignment_actions paa,
4212: per_all_assignments_f paf,
4213: per_all_people_f pap,
4214: per_periods_of_service pos,
4215: pay_message_lines pml
4216: where pay.payroll_action_id = p_pact_id
4217: and paa.payroll_action_id = pay.payroll_action_id