APPS.CE_AUTO_BANK_MATCH dependencies on CE_BANK_ACCOUNTS

Line 16: FROM ce_bank_accounts aba

12: IS
13: SELECT aba.bank_account_id,
14: aba.ACCOUNT_OWNER_ORG_ID,
15: -1 /* for JEC - replace cash account GL CCID here*/
16: FROM ce_bank_accounts aba
17: WHERE aba.bank_branch_id = p_bank_branch_id
18: AND aba.bank_account_id = NVL(p_bank_account_id, aba.bank_account_id)
19: AND aba.account_classification = 'INTERNAL'
20: AND EXISTS (

Line 44: FROM ce_bank_accts_gt_v aba, --ce_bank_accounts_v aba,

40: aba.multi_currency_allowed_flag,
41: aba.check_digits,
42: csh.rowid,
43: NVL(csh.statement_complete_flag,'N')
44: FROM ce_bank_accts_gt_v aba, --ce_bank_accounts_v aba,
45: ce_statement_headers csh
46: WHERE aba.bank_account_id = NVL(p_bank_account_id,aba.bank_account_id)
47: AND aba.bank_account_id = csh.bank_account_id
48: AND csh.statement_number

Line 1104: FROM CE_BANK_ACCOUNTS

1100: -- Bug 12564116 Start
1101: -- Get the exchange rate type from bank account setup.
1102: SELECT Nvl(RECON_FOREIGN_BANK_XRATE_TYPE,'User')
1103: INTO CE_AUTO_BANK_MATCH.csl_exchange_rate_type
1104: FROM CE_BANK_ACCOUNTS
1105: WHERE BANK_ACCOUNT_ID = CE_AUTO_BANK_MATCH.CSH_BANK_ACCOUNT_ID ;
1106: -- Bug 12564116 End.
1107:
1108: cep_standard.debug('xtype: '||CE_AUTO_BANK_MATCH.csl_exchange_rate_type);

Line 2201: ce_bank_accounts ba,

2197: FROM gl_sets_of_books sob,
2198: ce_system_parameters sp,
2199: ce_statement_reconcils_all rec,
2200: ce_bank_acct_uses_ou_v aba,
2201: ce_bank_accounts ba,
2202: --ce_bank_acct_uses_ou_v aba2, -- Bug 9062935 removed use of view
2203: iby_ext_bank_accounts ext, -- Bug 9062935
2204: --ce_bank_accounts ba2, -- Bug 9361270 Commented Line
2205: ap_payment_history_all aph,

Line 2204: --ce_bank_accounts ba2, -- Bug 9361270 Commented Line

2200: ce_bank_acct_uses_ou_v aba,
2201: ce_bank_accounts ba,
2202: --ce_bank_acct_uses_ou_v aba2, -- Bug 9062935 removed use of view
2203: iby_ext_bank_accounts ext, -- Bug 9062935
2204: --ce_bank_accounts ba2, -- Bug 9361270 Commented Line
2205: ap_payment_history_all aph,
2206: ap_checks_all c,
2207: ap_invoice_payments_all pay,
2208: ap_invoices_all inv,

Line 2307: ce_bank_accounts ba,

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,
2311: ar_cash_receipts_all cr,

Line 2485: ce_bank_accounts ba,

2481: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2482: FROM gl_sets_of_books sob,
2483: ce_system_parameters sp,
2484: ce_statement_reconcils_all rec,
2485: ce_bank_accounts ba,
2486: ce_bank_acct_uses_ou_v aba,
2487: ap_payment_history_all aph,
2488: ap_checks_all c,
2489: ap_invoice_payments_all pay,

Line 2581: ce_bank_accounts ba,

2577: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2578: FROM gl_sets_of_books sob,
2579: ce_system_parameters sp,
2580: ce_statement_reconcils_all rec,
2581: ce_bank_accounts ba,
2582: ce_bank_acct_uses_ou_v aba,
2583: ar_cash_receipt_history_all crh,
2584: ar_cash_receipts_all cr,
2585: ar_receivable_applications_all ra,

Line 7125: from ce_bank_accts_gt_v --ce_BANK_ACCOUNTS_v

7121:
7122: IF (x_bank_account_id is not null)
7123: select ACCOUNT_OWNER_ORG_ID
7124: into p_le_id
7125: from ce_bank_accts_gt_v --ce_BANK_ACCOUNTS_v
7126: where BANK_ACCOUNT_ID = x_bank_account_id;
7127:
7128: select AMOUNT_TOLERANCE_OLD,
7129: PERCENT_TOLERANCE_OLD,

Line 7495: FROM CE_BANK_ACCOUNTS

7491: cep_standard.debug('Fetching LE ID from Bank Acc ID.');
7492: -- l_le_id := nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id) ;
7493: SELECT ACCOUNT_OWNER_ORG_ID
7494: INTO L_LE_ID
7495: FROM CE_BANK_ACCOUNTS
7496: WHERE BANK_ACCOUNT_ID = CE_AUTO_BANK_MATCH.CSH_BANK_ACCOUNT_ID ;
7497: cep_standard.debug('New LE Id = ' || l_le_id);
7498: -- Bug 12989812 End
7499: end;