DBA Data[Home] [Help]

APPS.PAY_NL_TAXOFFICE_ARCHIVE dependencies on PER_PEOPLE_F

Line 176: FROM per_people_f ppf

172: /*Return the SELECT Statement to select a range of assignments
173: eligible for archival */
174:
175: sqlstr := 'SELECT DISTINCT person_id
176: FROM per_people_f ppf
177: ,pay_payroll_actions ppa
178: WHERE ppa.payroll_action_id = :payroll_action_id
179: AND ppa.business_group_id = ppf.business_group_id
180: ORDER BY ppf.person_id';

Line 229: per_people_f pap

225: paa.organization_id,
226: pap.person_id , paa.assignment_id, paa.assignment_number,
227: pap.last_name, pap.Date_of_Birth, pap.full_name
228: FROM
229: per_people_f pap
230: ,per_assignments_f paa
231: ,pay_all_payrolls_f ppf
232: -- per_all_people_f pap Performance fix 5042871
233: -- ,per_all_assignments_f paa