DBA Data[Home] [Help]

APPS.PAY_SG_IRAS_ARCHIVE_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 223: per_people_f pap

219: paa.person_id,
220: pac.assignment_id
221: from pay_assignment_actions pac,
222: per_assignments_f paa,
223: per_people_f pap
224: where pac.assignment_action_id = c_assignment_action_id
225: and paa.assignment_id = pac.assignment_id
226: and paa.person_id = pap.person_id;
227: --