APPS.PYCADAR_PKG dependencies on PAY_PRE_PAYMENTS

Line 359: from pay_pre_payments ppp

355: select 1
356: from dual
357: where not exists
358: (select 1
359: from pay_pre_payments ppp
360: where ppp.assignment_action_id = cp_prepayment_action_id
361: );
362:
363: lc_dd_flag VARCHAR2(1);

Line 455: FROM pay_pre_payments ppp,

451: ppa_dar.legislative_parameters)
452: is null)
453: -- No run results.
454: AND NOT EXISTS (SELECT ' '
455: FROM pay_pre_payments ppp,
456: pay_org_payment_methods_f popm
457: WHERE ppp.assignment_action_id = act.assignment_action_id
458: and ppp.org_payment_method_id = popm.org_payment_method_id
459: and popm.defined_balance_id IS NOT NULL)

Line 579: from pay_pre_payments ppp

575: ** Seperate Depsoit Advice for Seperate Check and Regular Run
576: *****************************************************************/
577: cursor c_payments (cp_pre_pymt_action_id in number) is
578: select distinct ppp.source_action_id
579: from pay_pre_payments ppp
580: where ppp.assignment_action_id = cp_pre_pymt_action_id
581: order by ppp.source_action_id;
582:
583: cursor c_payroll_run (cp_pre_pymt_action_id in number) is