APPS.CE_AUTO_BANK_MATCH dependencies on CE_BANK_ACCT_USES_GT_V

Line 22: FROM ce_bank_acct_uses_gt_v bau

18: AND aba.bank_account_id = NVL(p_bank_account_id, aba.bank_account_id)
19: AND aba.account_classification = 'INTERNAL'
20: AND EXISTS (
21: SELECT 1
22: FROM ce_bank_acct_uses_gt_v bau
23: WHERE bau.bank_account_id = aba.bank_account_id
24: AND SYSDATE <= NVL(bau.end_date,SYSDATE)
25: AND (bau.org_id = NVL(p_org_id, bau.org_id)
26: OR bau.legal_entity_id = NVL(p_legal_entity_id,bau.legal_entity_id)))

Line 7432: and exists (select 1 from ce_bank_acct_uses_gt_v bau

7428: --AND arm.receipt_method_id = nvl(CE_AUTO_BANK_REC.G_payment_method_id,CE_AUTO_BANK_MATCH.csl_receipt_method_id)
7429: AND arm.receipt_method_id = nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_id, CE_AUTO_BANK_REC.G_payment_method_id)
7430: AND CE_AUTO_BANK_MATCH.csl_trx_date between nvl(arm.start_date,CE_AUTO_BANK_MATCH.csl_trx_date)
7431: AND nvl(arm.end_date,CE_AUTO_BANK_MATCH.csl_trx_date)
7432: and exists (select 1 from ce_bank_acct_uses_gt_v bau
7433: where bau.bank_acct_use_id = arma.REMIT_BANK_ACCT_USE_ID
7434: and bau.bank_account_id =CE_AUTO_BANK_MATCH.csh_bank_account_id
7435: and bau.AR_USE_ENABLE_FLAG = 'Y' );
7436: cep_standard.debug('<