APPS.PAY_AU_PAYMENT_SUMMARY_REPORT dependencies on PER_PEOPLE_F

Line 53: ' from per_people_f p,' ||

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

Line 93: per_people_f p,

89: select distinct a.assignment_id,
90: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
91: ppac.assignment_action_id
92: from per_assignments_f a,
93: per_people_f p,
94: pay_payroll_actions pa,
95: pay_payroll_actions ppa,
96: pay_assignment_actions ppac
97: where pa.payroll_action_id = c_payroll_action_id

Line 157: ,per_people_f p

153: ,pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id
154: ,ppac.assignment_action_id
155: ,pmaa.assignment_action_id datafile_action_id
156: FROM per_assignments_f a
157: ,per_people_f p
158: ,pay_payroll_actions pa
159: ,pay_payroll_actions ppa
160: ,pay_assignment_actions ppac
161: ,pay_assignment_actions pmaa