DBA Data[Home] [Help]

APPS.PAY_SG_IRAS_AMEND_SETUP dependencies on PER_PEOPLE_F

Line 21: 'from per_people_f ppf, ' ||

17: hr_utility.trace(l_package_name||'range_code - Start');
18: end if;
19: --
20: p_sql := 'select distinct person_id ' ||
21: 'from per_people_f ppf, ' ||
22: 'pay_payroll_actions ppa ' ||
23: 'where ppa.payroll_action_id = :payroll_action_id ' ||
24: 'and ppa.business_group_id = ppf.business_group_id ' ||
25: 'order by ppf.person_id';

Line 232: per_people_f pap

228: paa.person_id,
229: pac.assignment_id
230: from pay_assignment_actions pac,
231: per_assignments_f paa,
232: per_people_f pap
233: where pac.assignment_action_id = c_assignment_action_id
234: and paa.assignment_id = pac.assignment_id
235: and paa.person_id = pap.person_id;
236: --