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 PER_ASSIGNMENTS_F

Line 136: per_assignments_f a

132: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
133: paa.assignment_action_id ps_report_id,
134: paa.assignment_id
135: FROM pay_assignment_actions paa,
136: per_assignments_f a
137: WHERE paa.payroll_action_id = c_payroll_action_id
138: AND paa.action_status = 'C'
139: AND a.assignment_id = paa.assignment_id
140: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG',paa.assignment_action_id)='YES'

Line 154: per_assignments_f a,

150: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
151: paa.assignment_action_id ps_report_id,
152: paa.assignment_id
153: FROM pay_assignment_actions paa,
154: per_assignments_f a,
155: pay_population_ranges ppr
156: WHERE paa.payroll_action_id = c_payroll_action_id
157: AND ppr.payroll_action_id = p_payroll_action_id
158: AND ppr.chunk_number = c_chunk

Line 178: INDEX(a PER_ASSIGNMENTS_F_PK) */

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
182: FROM pay_payroll_actions mpa,

Line 184: per_assignments_f a,

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,
188: pay_assignment_actions ppac,

Line 241: INDEX (a PER_ASSIGNMENTS_F_N12)

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)
244: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
245: */

Line 252: per_assignments_f a,

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,
256: pay_assignment_actions ppac,

Line 308: per_assignments_f a,

304: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
305: paa.assignment_action_id ps_report_id,
306: paa.assignment_id
307: FROM pay_assignment_actions paa,
308: per_assignments_f a,
309: pay_payroll_actions ppa
310: WHERE ppa.payroll_action_id = c_payroll_action_id
311: AND ppa.payroll_action_id = paa.payroll_action_id
312: AND ppa.action_status = 'C'

Line 330: per_assignments_f a,

326: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
327: paa.assignment_action_id ps_report_id,
328: paa.assignment_id
329: FROM pay_assignment_actions paa,
330: per_assignments_f a,
331: pay_population_ranges ppr
332: WHERE paa.payroll_action_id = c_payroll_action_id
333: AND ppr.payroll_action_id = p_payroll_action_id
334: AND ppr.chunk_number = c_chunk

Line 352: INDEX(a PER_ASSIGNMENTS_F_PK) */

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
356: FROM pay_payroll_actions mpa,

Line 358: per_assignments_f a,

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,
362: pay_assignment_actions ppac,

Line 409: INDEX(a PER_ASSIGNMENTS_F_PK) */

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
413: FROM pay_payroll_actions mpa,

Line 415: per_assignments_f a,

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,
419: pay_assignment_actions ppac,