APPS.CE_AUTO_BANK_MATCH dependencies on CE_BANK_ACCT_USES_ALL

Line 2306: ce_bank_acct_uses_all aba,

2302: gl_sets_of_books sob,
2303: ce_system_parameters sp,
2304: ce_statement_reconcils_all rec,
2305: /* Bug 13610807: do not use ce_bank_acct_uses_ou_v aba*/
2306: ce_bank_acct_uses_all aba,
2307: ce_bank_accounts ba,
2308: /* Bug 13610807: for customer account join with ext accts table */
2309: iby_ext_bank_accounts ext,
2310: ar_cash_receipt_history_all crh,

Line 7613: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU

7609:
7610: -- IS AP ACCOUNT?
7611: Select count(*)
7612: into x_ap_count
7613: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU
7614: where AP_USE_ENABLE_FLAG = 'Y'
7615: and sysdate <= nvl(end_date,sysdate)
7616: and BANK_ACCOUNT_ID = x_bank_account_id
7617: and BAU.ORG_ID = OU.ORGANIZATION_ID

Line 7630: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU

7626:
7627: -- IS AR ACCOUNT?
7628: Select count(*)
7629: into x_ar_count
7630: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU
7631: where AR_USE_ENABLE_FLAG = 'Y'
7632: and sysdate <= nvl(end_date,sysdate)
7633: and BANK_ACCOUNT_ID = x_bank_account_id
7634: and BAU.ORG_ID = OU.ORGANIZATION_ID

Line 7646: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU

7642:
7643: -- IS xtr ACCOUNT?
7644: Select count(*)
7645: into x_xtr_count
7646: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU
7647: where XTR_USE_ENABLE_FLAG = 'Y'
7648: and sysdate <= nvl(end_date,sysdate)
7649: and BANK_ACCOUNT_ID = x_bank_account_id
7650: and BAU.LEGAL_ENTITY_ID = OU.ORGANIZATION_ID --BUG 5122576

Line 7662: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU

7658:
7659: -- IS pay ACCOUNT?
7660: Select count(*)
7661: into x_pay_count
7662: from ce_bank_acct_uses_all bau, CE_SECURITY_PROFILES_GT OU
7663: where PAY_USE_ENABLE_FLAG = 'Y'
7664: and sysdate <= nvl(end_date,sysdate)
7665: and BANK_ACCOUNT_ID = x_bank_account_id
7666: and BAU.ORG_ID = OU.ORGANIZATION_ID