APPS.PAY_SG_IRAS_MAGTAPE dependencies on PER_PEOPLE_F

Line 19: 'from per_people_f ppf, ' ||

15: begin
16: hr_utility.set_location('Start of range_code',1);
17:
18: p_sql := 'select distinct person_id ' ||
19: 'from per_people_f ppf, ' ||
20: 'pay_payroll_actions ppa ' ||
21: 'where ppa.payroll_action_id = :payroll_action_id ' ||
22: 'and ppa.business_group_id = ppf.business_group_id ' ||
23: 'order by ppf.person_id';

Line 57: per_people_f p,

53: select distinct a.assignment_id,
54: pay_core_utils.get_parameter('ARCHIVE_RUN_ID', pa.legislative_parameters) archive_run_id,
55: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', pa.legislative_parameters) legal_entity_id
56: from per_assignments_f a, /* Bug# 2920732 */
57: per_people_f p,
58: pay_payroll_actions pa
59: where pa.payroll_action_id = c_payroll_action_id
60: and p.person_id between c_start_person_id and c_end_person_id
61: and p.person_id = a.person_id