APPS.PY_ROLLBACK_PKG dependencies on PAY_EXTERNAL_ACCOUNTS

Line 501: from pay_external_accounts pea,

497: */
498: procedure reset_prenote(p_assact_id in number) is
499: cursor get_accnts_to_reset(asgact in number) is
500: select pea.external_account_id
501: from pay_external_accounts pea,
502: pay_payment_types ppt,
503: pay_personal_payment_methods_f ppm,
504: pay_org_payment_methods_f opm,
505: pay_pre_payments ppp,

Line 523: update pay_external_accounts

519: and ppa.effective_date between opm.effective_start_date
520: and opm.effective_end_date;
521: begin
522: for eacrec in get_accnts_to_reset(p_assact_id) loop
523: update pay_external_accounts
524: set prenote_date = null
525: where external_account_id = eacrec.external_account_id
526: and prenote_date is not null;
527: end loop;