APPS.PAY_AU_PAYMENT_SUMMARY_AMEND dependencies on PER_PEOPLE_F

Line 88: ' from per_people_f p,' ||

84: hr_utility.set_location('Start of range_code ',1);
85: END IF;
86:
87: p_sql := ' select distinct p.person_id' ||
88: ' from per_people_f p,' ||
89: ' pay_payroll_actions pa' ||
90: ' where pa.payroll_action_id = :payroll_action_id' ||
91: ' and p.business_group_id = pa.business_group_id' ||
92: ' order by p.person_id';

Line 277: ,per_people_f ppf

273: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
274: IS
275: SELECT DISTINCT paf.assignment_id
276: FROM per_assignments_f paf
277: ,per_people_f ppf
278: ,pay_payroll_actions ppa
279: WHERE ppa.payroll_action_id = c_payroll_action_id
280: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id
281: AND ppf.person_id = paf.person_id

Line 323: ,per_people_f ppf

319: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
320: IS
321: SELECT DISTINCT paf.assignment_id
322: FROM per_assignments_f paf
323: ,per_people_f ppf
324: ,pay_payroll_actions ppa
325: WHERE ppa.payroll_action_id = c_payroll_action_id
326: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id
327: AND ppf.person_id = paf.person_id

Line 354: ,per_people_f ppf

350: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
351: IS
352: SELECT DISTINCT paf.assignment_id
353: FROM per_assignments_f paf
354: ,per_people_f ppf
355: ,pay_payroll_actions ppa
356: ,hr_assignment_set_amendments has
357: WHERE ppa.payroll_action_id = c_payroll_action_id
358: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id

Line 403: ,per_people_f ppf

399: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
400: IS
401: SELECT DISTINCT paf.assignment_id
402: FROM per_assignments_f paf
403: ,per_people_f ppf
404: ,pay_payroll_actions ppa
405: ,hr_assignment_set_amendments has
406: WHERE ppa.payroll_action_id = c_payroll_action_id
407: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id