APPS.PYUSDAR_PKG dependencies on PAY_PRE_PAYMENTS

Line 275: FROM pay_pre_payments ppp,

271: ppa_dar.legislative_parameters)
272: is null)
273: -- No run results.
274: AND NOT EXISTS (SELECT ' '
275: FROM pay_pre_payments ppp,
276: pay_org_payment_methods_f popm
277: WHERE ppp.assignment_action_id = act.assignment_action_id
278: and ppp.org_payment_method_id = popm.org_payment_method_id
279: and popm.defined_balance_id IS NOT NULL)

Line 332: from pay_pre_payments ppp,

328: *****************************************************************/
329: cursor c_payments (cp_pre_pymt_action_id in number,
330: cp_effective_date in date) is
331: select distinct ppp.source_action_id
332: from pay_pre_payments ppp,
333: pay_personal_payment_methods_f pppm
334: where ppp.assignment_action_id = cp_pre_pymt_action_id
335: and pppm.personal_payment_method_id = ppp.personal_payment_method_id
336: and pppm.external_account_id is not null

Line 779: from pay_pre_payments ppp

775: (nvl(pay.multi_assignments_flag, 'N') = 'N')
776: )
777: -- **********************************************************************
778: and not exists (select ' '
779: from pay_pre_payments ppp
780: where ppp.assignment_action_id = pai_pre.locked_action_id
781: )
782:
783: /* XFR => PRE */