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 89: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)

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

Line 102: pay_action_interlocks ppai

98: pay_payroll_actions apa,
99: pay_assignment_actions apac,
100: pay_payroll_actions ppa,
101: pay_assignment_actions ppac,
102: pay_action_interlocks ppai
103: WHERE mpa.payroll_action_id =c_payroll_action_id
104: AND p.person_id = a.person_id
105: AND p.person_id BETWEEN c_start_person_id AND c_end_person_id
106: AND p.business_group_id = mpa.business_group_id

Line 126: FROM pay_action_interlocks pail,

122: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
123: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
124: AND NOT EXISTS /* 5471093 */
125: (SELECT /*+ ORDERED */ locked_action_id
126: FROM pay_action_interlocks pail,
127: pay_assignment_actions paa1,
128: pay_payroll_actions paas
129: WHERE paas.action_type='X'
130: and paas.action_status='C'

Line 166: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)

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

Line 179: pay_action_interlocks ppai

175: pay_payroll_actions apa,
176: pay_assignment_actions apac,
177: pay_payroll_actions ppa,
178: pay_assignment_actions ppac,
179: pay_action_interlocks ppai
180: WHERE mpa.payroll_action_id =c_payroll_action_id
181: AND p.person_id = a.person_id
182: AND p.person_id BETWEEN c_start_person_id AND c_end_person_id
183: AND p.business_group_id = mpa.business_group_id

Line 204: FROM pay_action_interlocks pail,

200: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
201: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'
202: AND NOT EXISTS /* 5471093 */
203: (SELECT /*+ ORDERED */ locked_action_id
204: FROM pay_action_interlocks pail,
205: pay_assignment_actions paa1,
206: pay_payroll_actions paas
207: WHERE paas.action_type='X'
208: and paas.action_status='C'