APPS.PAY_GB_DEO dependencies on PER_ALL_PEOPLE_F

Line 130: per_all_people_f pap

126: substr(pap.national_identifier,1,9) national_identifier,
127: pap.effective_start_date effective_start_date
128: FROM pay_assignment_actions act,
129: per_all_assignments_f paa,
130: per_all_people_f pap
131: where act.assignment_action_id = p_assactid
132: and act.assignment_id = paa.assignment_id
133: and paa.person_id = pap.person_id
134: and pap.effective_start_date <= p_effective_date

Line 264: 'from per_all_people_f ppf, '||

260: fnd_file.put_line(FND_FILE.log, 'Rep_type:'||l_report_type);
261: IF l_report_type = 'DEO_PAY_REP' THEN
262:
263: sqlstr := 'select distinct person_id '||
264: 'from per_all_people_f ppf, '||
265: 'pay_payroll_actions ppa '||
266: 'where ppa.payroll_action_id = :payroll_action_id '||
267: 'and ppa.business_group_id = ppf.business_group_id '||
268: 'order by ppf.person_id';