APPS.CE_AUTO_BANK_MATCH dependencies on CE_BANK_ACCT_USES_GT_V

Line 35: and exists (select 1 from ce_bank_acct_uses_gt_v bau

31: --AND aba.bank_account_id = bau.bank_account_id
32: --and sysdate <= nvl(bau.end_date,sysdate)
33: AND aba.account_classification = 'INTERNAL'
34: --and aba.ACCOUNT_OWNER_ORG_ID = nvl(p_legal_entity_id,aba.ACCOUNT_OWNER_ORG_ID)
35: and exists (select 1 from ce_bank_acct_uses_gt_v bau
36: where bau.bank_account_id = aba.bank_account_id
37: and sysdate <= nvl(bau.end_date,sysdate)
38: and (bau.org_id = nvl(p_org_id, bau.org_id) or
39: bau.legal_entity_id = nvl(p_legal_entity_id,bau.legal_entity_id)))

Line 7243: and exists (select 1 from ce_bank_acct_uses_gt_v bau

7239: --AND arm.receipt_method_id = nvl(CE_AUTO_BANK_REC.G_payment_method_id,CE_AUTO_BANK_MATCH.csl_receipt_method_id)
7240: AND arm.receipt_method_id = nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_id, CE_AUTO_BANK_REC.G_payment_method_id)
7241: AND CE_AUTO_BANK_MATCH.csl_trx_date between nvl(arm.start_date,CE_AUTO_BANK_MATCH.csl_trx_date)
7242: AND nvl(arm.end_date,CE_AUTO_BANK_MATCH.csl_trx_date)
7243: and exists (select 1 from ce_bank_acct_uses_gt_v bau
7244: where bau.bank_acct_use_id = arma.REMIT_BANK_ACCT_USE_ID
7245: and bau.bank_account_id =CE_AUTO_BANK_MATCH.csh_bank_account_id
7246: and bau.AR_USE_ENABLE_FLAG = 'Y' );
7247: cep_standard.debug('<