DBA Data[Home] [Help]

APPS.PAY_US_NACHA_TAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 219: pay_assignment_actions pyaact

215: and hroinf.org_information2 = 'Y'
216: and EXISTS
217: ( select 1
218: from per_assignments_f perasg,
219: pay_assignment_actions pyaact
220: where pyaact.payroll_action_id = p_payroll_action_id
221: and pyaact.tax_unit_id = hrorgu.organization_id
222: and perasg.assignment_id = pyaact.assignment_id
223: and g_effective_date between perasg.effective_start_date

Line 242: from pay_assignment_actions paa,

238: ppp.value,
239: ppp.personal_payment_method_id,
240: ppp.pre_payment_id,
241: ppp.rowid
242: from pay_assignment_actions paa,
243: pay_pre_payments ppp
244: where ppp.org_payment_method_id+0 = p_org_payment_method_id -- suppressing index for performance improvement Bug 3587226
245: and ppp.PRE_PAYMENT_ID = paa.PRE_PAYMENT_ID
246: and paa.PAYROLL_ACTION_ID = p_payroll_action_id

Line 278: from pay_assignment_actions paa,

274: ppp.value,
275: ppp.personal_payment_method_id,
276: ppp.pre_payment_id,
277: ppp.rowid
278: from pay_assignment_actions paa,
279: pay_pre_payments ppp
280: where ppp.org_payment_method_id = p_org_payment_method_id
281: and ppp.PRE_PAYMENT_ID = paa.PRE_PAYMENT_ID
282: and paa.PAYROLL_ACTION_ID = p_payroll_action_id