APPS.PY_ROLLBACK_PKG dependencies on PAY_EXTERNAL_ACCOUNTS

Line 506: from pay_external_accounts pea,

502: */
503: procedure reset_prenote(p_assact_id in number) is
504: cursor get_accnts_to_reset(asgact in number) is
505: select pea.external_account_id
506: from pay_external_accounts pea,
507: pay_payment_types ppt,
508: pay_personal_payment_methods_f ppm,
509: pay_org_payment_methods_f opm,
510: pay_pre_payments ppp,

Line 528: update pay_external_accounts

524: and ppa.effective_date between opm.effective_start_date
525: and opm.effective_end_date;
526: begin
527: for eacrec in get_accnts_to_reset(p_assact_id) loop
528: update pay_external_accounts
529: set prenote_date = null
530: where external_account_id = eacrec.external_account_id
531: and prenote_date is not null;
532: end loop;