APPS.PYCADAR_PKG dependencies on PAY_PRE_PAYMENTS

Line 322: from pay_pre_payments ppp

318: select 1
319: from dual
320: where not exists
321: (select 1
322: from pay_pre_payments ppp
323: where ppp.assignment_action_id = cp_prepayment_action_id
324: );
325:
326: lc_dd_flag VARCHAR2(1);

Line 418: FROM pay_pre_payments ppp,

414: ppa_dar.legislative_parameters)
415: is null)
416: -- No run results.
417: AND NOT EXISTS (SELECT ' '
418: FROM pay_pre_payments ppp,
419: pay_org_payment_methods_f popm
420: WHERE ppp.assignment_action_id = act.assignment_action_id
421: and ppp.org_payment_method_id = popm.org_payment_method_id
422: and popm.defined_balance_id IS NOT NULL)

Line 542: from pay_pre_payments ppp

538: ** Seperate Depsoit Advice for Seperate Check and Regular Run
539: *****************************************************************/
540: cursor c_payments (cp_pre_pymt_action_id in number) is
541: select distinct ppp.source_action_id
542: from pay_pre_payments ppp
543: where ppp.assignment_action_id = cp_pre_pymt_action_id
544: order by ppp.source_action_id;
545:
546: cursor c_payroll_run (cp_pre_pymt_action_id in number) is