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 70: per_assignments_f a

66: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
67: paa.assignment_action_id ps_report_id,
68: paa.assignment_id
69: FROM pay_assignment_actions paa,
70: per_assignments_f a
71: WHERE paa.payroll_action_id = c_payroll_action_id
72: AND paa.action_status = 'C'
73: AND a.assignment_id = paa.assignment_id
74: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG',paa.assignment_action_id)='YES'

Line 91: INDEX(a PER_ASSIGNMENTS_F_PK) */

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

Line 97: per_assignments_f a,

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

Line 146: per_assignments_f a,

142: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
143: paa.assignment_action_id ps_report_id,
144: paa.assignment_id
145: FROM pay_assignment_actions paa,
146: per_assignments_f a,
147: pay_payroll_actions ppa
148: WHERE ppa.payroll_action_id = c_payroll_action_id
149: AND ppa.payroll_action_id = paa.payroll_action_id
150: AND ppa.action_status = 'C'

Line 168: INDEX(a PER_ASSIGNMENTS_F_PK) */

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

Line 174: per_assignments_f a,

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