eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

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 177: INDEX (p PER_PEOPLE_F_PK)

173: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
174: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
175: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
176: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)
177: INDEX (p PER_PEOPLE_F_PK)
178: INDEX(a PER_ASSIGNMENTS_F_PK) */
179: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
180: ppac.assignment_action_id ps_report_id,
181: ppac.assignment_id

Line 183: per_people_f p,

179: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
180: ppac.assignment_action_id ps_report_id,
181: ppac.assignment_id
182: FROM pay_payroll_actions mpa,
183: per_people_f p,
184: per_assignments_f a,
185: pay_payroll_actions apa,
186: pay_assignment_actions apac,
187: pay_payroll_actions ppa,

Line 239: INDEX (p PER_PEOPLE_F_PK)

235: c_chunk IN NUMBER)
236: IS
237: SELECT /*+ INDEX (mpa PAY_PAYROLL_ACTIONS_PK)
238: INDEX (ppr PAY_POPULATION_RANGES_N4)
239: INDEX (p PER_PEOPLE_F_PK)
240: INDEX (apa PAY_PAYROLL_ACTIONS_N52)
241: INDEX (a PER_ASSIGNMENTS_F_N12)
242: INDEX (apac PAY_ASSIGNMENT_ACTIONS_N51)
243: INDEX (ppai PAY_ACTION_INTERLOCKS_FK2)

Line 251: per_people_f p,

247: ppac.assignment_action_id ps_report_id,
248: ppac.assignment_id
249: FROM pay_payroll_actions mpa,
250: pay_population_ranges ppr,
251: per_people_f p,
252: per_assignments_f a,
253: pay_payroll_actions apa,
254: pay_assignment_actions apac,
255: pay_payroll_actions ppa,

Line 351: INDEX (p PER_PEOPLE_F_PK)

347: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
348: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
349: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
350: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)
351: INDEX (p PER_PEOPLE_F_PK)
352: INDEX(a PER_ASSIGNMENTS_F_PK) */
353: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
354: ppac.assignment_action_id ps_report_id,
355: ppac.assignment_id

Line 357: per_people_f p,

353: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
354: ppac.assignment_action_id ps_report_id,
355: ppac.assignment_id
356: FROM pay_payroll_actions mpa,
357: per_people_f p,
358: per_assignments_f a,
359: pay_payroll_actions apa,
360: pay_assignment_actions apac,
361: pay_payroll_actions ppa,

Line 408: INDEX (p PER_PEOPLE_F_PK)

404: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
405: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
406: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
407: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)
408: INDEX (p PER_PEOPLE_F_PK)
409: INDEX(a PER_ASSIGNMENTS_F_PK) */
410: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
411: ppac.assignment_action_id ps_report_id,
412: ppac.assignment_id

Line 414: per_people_f p,

410: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
411: ppac.assignment_action_id ps_report_id,
412: ppac.assignment_id
413: FROM pay_payroll_actions mpa,
414: per_people_f p,
415: per_assignments_f a,
416: pay_payroll_actions apa,
417: pay_assignment_actions apac,
418: pay_payroll_actions ppa,