APPS.PAY_AU_PAYMENT_SUMMARY_MAGTAPE dependencies on PER_PEOPLE_F

Line 18: ' from per_people_f p,' ||

14: hr_utility.set_location('Start of range_code',1);
15: /*Bug2920725 Corrected base tables to support security model*/
16:
17: p_sql := ' select distinct p.person_id' ||
18: ' from per_people_f p,' ||
19: ' pay_payroll_actions pa ' ||
20: ' where pa.payroll_action_id = :payroll_action_id' ||
21: ' and p.business_group_id = pa.business_group_id' ||
22: ' order by p.person_id';

Line 90: INDEX (p PER_PEOPLE_F_PK)

86: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
87: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
88: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
89: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)
90: INDEX (p PER_PEOPLE_F_PK)
91: INDEX(a PER_ASSIGNMENTS_F_PK) */
92: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
93: ppac.assignment_action_id ps_report_id,
94: ppac.assignment_id

Line 96: per_people_f p,

92: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
93: ppac.assignment_action_id ps_report_id,
94: ppac.assignment_id
95: FROM pay_payroll_actions mpa,
96: per_people_f p,
97: per_assignments_f a,
98: pay_payroll_actions apa,
99: pay_assignment_actions apac,
100: pay_payroll_actions ppa,

Line 167: INDEX (p PER_PEOPLE_F_PK)

163: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
164: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
165: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
166: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)
167: INDEX (p PER_PEOPLE_F_PK)
168: INDEX(a PER_ASSIGNMENTS_F_PK) */
169: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
170: ppac.assignment_action_id ps_report_id,
171: ppac.assignment_id

Line 173: per_people_f p,

169: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
170: ppac.assignment_action_id ps_report_id,
171: ppac.assignment_id
172: FROM pay_payroll_actions mpa,
173: per_people_f p,
174: per_assignments_f a,
175: pay_payroll_actions apa,
176: pay_assignment_actions apac,
177: pay_payroll_actions ppa,