DBA Data[Home] [Help]

APPS.PAY_US_NACHA_TAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 214: pay_assignment_actions pyaact

210: and hroinf.org_information2 = 'Y'
211: and EXISTS
212: ( select 1
213: from per_assignments_f perasg,
214: pay_assignment_actions pyaact
215: where pyaact.payroll_action_id = p_payroll_action_id
216: and pyaact.tax_unit_id = hrorgu.organization_id
217: and perasg.assignment_id = pyaact.assignment_id
218: and g_effective_date between perasg.effective_start_date

Line 237: from pay_assignment_actions paa,

233: ppp.value,
234: ppp.personal_payment_method_id,
235: ppp.pre_payment_id,
236: ppp.rowid
237: from pay_assignment_actions paa,
238: pay_pre_payments ppp
239: where ppp.org_payment_method_id+0 = p_org_payment_method_id -- suppressing index for performance improvement Bug 3587226
240: and ppp.PRE_PAYMENT_ID = paa.PRE_PAYMENT_ID
241: and paa.PAYROLL_ACTION_ID = p_payroll_action_id

Line 273: from pay_assignment_actions paa,

269: ppp.value,
270: ppp.personal_payment_method_id,
271: ppp.pre_payment_id,
272: ppp.rowid
273: from pay_assignment_actions paa,
274: pay_pre_payments ppp
275: where ppp.org_payment_method_id = p_org_payment_method_id
276: and ppp.PRE_PAYMENT_ID = paa.PRE_PAYMENT_ID
277: and paa.PAYROLL_ACTION_ID = p_payroll_action_id