APPS.PAY_AU_PAYMENT_SUMMARY_AMEND dependencies on PER_PEOPLE_F

Line 73: ' from per_people_f p,' ||

69: hr_utility.set_location('Start of range_code ',1);
70: END IF;
71:
72: p_sql := ' select distinct p.person_id' ||
73: ' from per_people_f p,' ||
74: ' pay_payroll_actions pa' ||
75: ' where pa.payroll_action_id = :payroll_action_id' ||
76: ' and p.business_group_id = pa.business_group_id' ||
77: ' order by p.person_id';

Line 197: ,per_people_f ppf

193: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
194: IS
195: SELECT DISTINCT paf.assignment_id
196: FROM per_assignments_f paf
197: ,per_people_f ppf
198: ,pay_payroll_actions ppa
199: WHERE ppa.payroll_action_id = c_payroll_action_id
200: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id
201: AND ppf.person_id = paf.person_id

Line 243: ,per_people_f ppf

239: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
240: IS
241: SELECT DISTINCT paf.assignment_id
242: FROM per_assignments_f paf
243: ,per_people_f ppf
244: ,pay_payroll_actions ppa
245: ,hr_assignment_set_amendments has
246: WHERE ppa.payroll_action_id = c_payroll_action_id
247: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id