APPS.PAY_US_NACHA_IAT_TAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 184: pay_assignment_actions pyaact,

180: AND hroinf.org_information2 = 'Y'
181: AND EXISTS
182: ( SELECT 1
183: FROM per_assignments_f perasg ,
184: pay_assignment_actions pyaact,
185: pay_pre_payments prepay -- Moved from outer query to subquery
186: WHERE pyaact.payroll_action_id = ppa.payroll_action_id
187: -- join now to outer query
188: AND pyaact.tax_unit_id = hrorgu.organization_id

Line 208: from pay_assignment_actions paa,

204: ppp.value,
205: ppp.personal_payment_method_id,
206: ppp.pre_payment_id,
207: ppp.rowid
208: from pay_assignment_actions paa,
209: pay_pre_payments ppp
210: where ppp.org_payment_method_id+0 = p_org_payment_method_id -- suppressing index for performance improvement Bug 3587226
211: and ppp.PRE_PAYMENT_ID = paa.PRE_PAYMENT_ID
212: and paa.PAYROLL_ACTION_ID = p_payroll_action_id

Line 230: from pay_assignment_actions paa,

226: ppp.value,
227: ppp.personal_payment_method_id,
228: ppp.pre_payment_id,
229: ppp.rowid
230: from pay_assignment_actions paa,
231: pay_pre_payments ppp
232: where ppp.org_payment_method_id = p_org_payment_method_id
233: and ppp.PRE_PAYMENT_ID = paa.PRE_PAYMENT_ID
234: and paa.PAYROLL_ACTION_ID = p_payroll_action_id