DBA Data[Home] [Help]

APPS.PAY_US_NACHA_TAPE dependencies on PAY_PRE_PAYMENTS

Line 197: pay_pre_payments prepay,

193: decode(nvl(to_char(opm.defined_balance_id),'Y'),'Y','Y','N'),
194: hrorgu.organization_id,
195: opm.pmeth_information6
196: from
197: pay_pre_payments prepay,
198: pay_org_payment_methods_f opm,
199: hr_organization_units hrorgu,
200: hr_organization_information hroinf
201: where

Line 238: pay_pre_payments ppp

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
242: and paa.tax_unit_id = p_legal_company_id -- ADDED for GRE join as the subquery is removed Bug 3587226

Line 274: pay_pre_payments ppp

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
278: and paa.tax_unit_id = p_legal_company_id -- ADDED for GRE join as the subquery is removed Bug 3587226