APPS.PAY_AU_PAYMENT_SUMMARY_REPORT dependencies on PER_PEOPLE_F

Line 57: ' from per_people_f p,' ||

53:
54: /*Bug2920725 Corrected base tables to support security model*/
55:
56: p_sql := ' select distinct p.person_id' ||
57: ' from per_people_f p,' ||
58: ' pay_payroll_actions pa' ||
59: ' where pa.payroll_action_id = :payroll_action_id' ||
60: ' and p.business_group_id = pa.business_group_id' ||
61: ' order by p.person_id';

Line 165: per_people_f p,

161: select distinct a.assignment_id,
162: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
163: ppac.assignment_action_id
164: from per_assignments_f a,
165: per_people_f p,
166: pay_payroll_actions pa,
167: pay_payroll_actions ppa,
168: pay_assignment_actions ppac
169: where pa.payroll_action_id = c_payroll_action_id

Line 219: per_people_f p,

215: ppac.assignment_action_id
216: FROM pay_payroll_actions pa,
217: pay_population_ranges ppr,
218: pay_payroll_actions ppa,
219: per_people_f p,
220: per_assignments_f a,
221: pay_assignment_actions ppac
222: WHERE pa.payroll_action_id = c_payroll_action_id
223: AND ppr.payroll_action_id = pa.payroll_action_id

Line 292: ,per_people_f p

288: ,pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id
289: ,ppac.assignment_action_id
290: ,pmaa.assignment_action_id datafile_action_id
291: FROM per_assignments_f a
292: ,per_people_f p
293: ,pay_payroll_actions pa
294: ,pay_payroll_actions ppa
295: ,pay_assignment_actions ppac
296: ,pay_assignment_actions pmaa

Line 351: ,per_people_f p

347: ,pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id
348: ,ppac.assignment_action_id
349: ,pmaa.assignment_action_id datafile_action_id
350: FROM per_assignments_f a
351: ,per_people_f p
352: ,pay_payroll_actions pa
353: ,pay_payroll_actions ppa
354: ,pay_assignment_actions ppac
355: ,pay_assignment_actions pmaa