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.

APPS.PAY_AU_PAYMENT_SUMMARY_MAGTAPE dependencies on PAY_ACTION_INTERLOCKS

Line 176: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)

172: c_end_person_id in per_all_people_f.person_id%type) is
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,

Line 189: pay_action_interlocks ppai

185: pay_payroll_actions apa,
186: pay_assignment_actions apac,
187: pay_payroll_actions ppa,
188: pay_assignment_actions ppac,
189: pay_action_interlocks ppai
190: WHERE mpa.payroll_action_id =c_payroll_action_id
191: AND p.person_id = a.person_id
192: AND p.person_id BETWEEN c_start_person_id AND c_end_person_id
193: AND p.business_group_id = mpa.business_group_id

Line 213: FROM pay_action_interlocks pail,

209: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
210: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
211: AND NOT EXISTS /* 5471093 */
212: (SELECT /*+ ORDERED */ locked_action_id
213: FROM pay_action_interlocks pail,
214: pay_assignment_actions paa1,
215: pay_payroll_actions paas
216: WHERE paas.action_type='X'
217: and paas.action_status='C'

Line 243: INDEX (ppai PAY_ACTION_INTERLOCKS_FK2)

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)
244: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
245: */
246: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
247: ppac.assignment_action_id ps_report_id,

Line 257: pay_action_interlocks ppai

253: pay_payroll_actions apa,
254: pay_assignment_actions apac,
255: pay_payroll_actions ppa,
256: pay_assignment_actions ppac,
257: pay_action_interlocks ppai
258: WHERE mpa.payroll_action_id = c_payroll_action_id
259: AND ppr.payroll_action_id = mpa.payroll_action_id
260: AND p.person_id = ppr.person_id
261: AND ppr.chunk_number = c_chunk

Line 286: FROM pay_action_interlocks pail,

282: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
283: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
284: AND NOT EXISTS /* 5471093 */
285: (SELECT locked_action_id
286: FROM pay_action_interlocks pail,
287: pay_assignment_actions paa1,
288: pay_payroll_actions paas
289: WHERE paas.report_type='AU_PS_DATA_FILE'
290: AND paas.report_qualifier = 'AU'

Line 350: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)

346: c_end_person_id in per_all_people_f.person_id%type) is
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,

Line 363: pay_action_interlocks ppai

359: pay_payroll_actions apa,
360: pay_assignment_actions apac,
361: pay_payroll_actions ppa,
362: pay_assignment_actions ppac,
363: pay_action_interlocks ppai
364: WHERE mpa.payroll_action_id =c_payroll_action_id
365: AND p.person_id = a.person_id
366: AND p.person_id BETWEEN c_start_person_id AND c_end_person_id
367: AND p.business_group_id = mpa.business_group_id

Line 388: FROM pay_action_interlocks pail,

384: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
385: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'
386: AND NOT EXISTS /* 5471093 */
387: (SELECT /*+ ORDERED */ locked_action_id
388: FROM pay_action_interlocks pail,
389: pay_assignment_actions paa1,
390: pay_payroll_actions paas
391: WHERE paas.action_type='X'
392: and paas.action_status='C'

Line 407: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)

403: c_chunk IN NUMBER) is
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,

Line 420: pay_action_interlocks ppai,

416: pay_payroll_actions apa,
417: pay_assignment_actions apac,
418: pay_payroll_actions ppa,
419: pay_assignment_actions ppac,
420: pay_action_interlocks ppai,
421: pay_population_ranges ppr
422: WHERE mpa.payroll_action_id =c_payroll_action_id
423: AND ppr.payroll_action_id = mpa.payroll_action_id
424: AND ppr.chunk_number = c_chunk

Line 448: FROM pay_action_interlocks pail,

444: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
445: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'
446: AND NOT EXISTS
447: (SELECT /*+ ORDERED */ locked_action_id
448: FROM pay_action_interlocks pail,
449: pay_assignment_actions paa1,
450: pay_payroll_actions paas
451: WHERE paas.action_type='X'
452: and paas.action_status='C'