DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_MATCH dependencies on AR_RECEIPT_METHOD_ACCOUNTS

Line 7420: FROM ar_receipt_method_accounts arma,

7416: cep_standard.debug('CE_AUTO_BANK_MATCH.trx_org_id '|| CE_AUTO_BANK_MATCH.trx_org_id);
7417:
7418: SELECT arm.name
7419: INTO CE_AUTO_BANK_REC.G_payment_method_name
7420: FROM ar_receipt_method_accounts arma,
7421: ar_receipt_methods arm
7422: WHERE arm.receipt_method_id = arma.receipt_method_id
7423: --AND arma.REMIT_BANK_ACCT_USE_ID = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
7424: AND arma.REMIT_BANK_ACCT_USE_ID = nvl(CE_AUTO_BANK_MATCH.trx_bank_acct_use_id, arma.REMIT_BANK_ACCT_USE_ID)