APPS.PAY_KW_PIFSS dependencies on PER_PEOPLE_F

Line 19: 'from per_people_f ppf, '||

15: -- Note: There must be one and only one entry of :payroll_action_id in
16: -- the string, and the statement must be, order by person_id
17: --
18: sqlstr := '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 42: per_people_f p,

38: select distinct a.assignment_id,
39: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
40: ppac.assignment_action_id
41: from per_assignments_f a,
42: per_people_f p,
43: pay_payroll_actions pa,
44: pay_payroll_actions ppa,
45: pay_assignment_actions ppac
46: where pa.payroll_action_id = c_payroll_action_id