APPS.PAY_NL_TAXOFFICE_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 232: -- per_all_people_f pap Performance fix 5042871

228: FROM
229: per_people_f pap
230: ,per_assignments_f paa
231: ,pay_all_payrolls_f ppf
232: -- per_all_people_f pap Performance fix 5042871
233: -- ,per_all_assignments_f paa
234: WHERE pap.business_group_id = lp_business_group_id
235: and pap.person_id = paa.person_id
236: and paa.person_id BETWEEN lp_start_person_id AND lp_end_person_id

Line 270: l_person_id per_all_people_f.person_id%TYPE;

266:
267: l_tax_year_start_date date;
268: l_tax_year_end_date date;
269: l_tax_year_date number;
270: l_person_id per_all_people_f.person_id%TYPE;
271: l_asg_start_date varchar2(255);
272: l_asg_end_date varchar2(255);
273: l_assgt_start_date date;
274: l_assgt_end_date date;