APPS.CE_AUTO_BANK_MATCH dependencies on CE_BANK_ACCOUNTS

Line 27: FROM ce_bank_accounts aba

23: nvl(bau.PAY_USE_ENABLE_FLAG,'N'),
24: decode(bau.org_id, -1, null, bau.org_id),
25: bau.legal_entity_id,*/
26: -1 /* for JEC - replace cash account GL CCID here*/
27: FROM ce_bank_accounts aba
28: --ce_bank_acct_uses bau
29: WHERE aba.bank_branch_id = p_bank_branch_id
30: AND aba.bank_account_id = NVL(p_bank_account_id, aba.bank_account_id)
31: --AND aba.bank_account_id = bau.bank_account_id

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

59: aba.multi_currency_allowed_flag,
60: aba.check_digits,
61: csh.rowid,
62: NVL(csh.statement_complete_flag,'N')
63: FROM ce_bank_accts_gt_v aba, --ce_bank_accounts_v aba,
64: ce_statement_headers csh
65: WHERE aba.bank_account_id = NVL(p_bank_account_id,aba.bank_account_id)
66: AND aba.bank_account_id = csh.bank_account_id
67: AND csh.statement_number

Line 2196: ce_bank_accounts ba,

2192: FROM gl_sets_of_books sob,
2193: ce_system_parameters sp,
2194: ce_statement_reconcils_all rec,
2195: ce_bank_acct_uses_ou_v aba,
2196: ce_bank_accounts ba,
2197: ce_bank_acct_uses_ou_v aba2,
2198: ce_bank_accounts ba2,
2199: ap_payment_history_all aph,
2200: ap_checks_all c,

Line 2198: ce_bank_accounts ba2,

2194: ce_statement_reconcils_all rec,
2195: ce_bank_acct_uses_ou_v aba,
2196: ce_bank_accounts ba,
2197: ce_bank_acct_uses_ou_v aba2,
2198: ce_bank_accounts ba2,
2199: ap_payment_history_all aph,
2200: ap_checks_all c,
2201: ap_invoice_payments_all pay,
2202: ap_invoices_all inv,

Line 2300: ce_bank_accounts ba,

2296: FROM gl_sets_of_books sob,
2297: ce_system_parameters sp,
2298: ce_statement_reconcils_all rec,
2299: ce_bank_acct_uses_ou_v aba,
2300: ce_bank_accounts ba,
2301: ce_bank_acct_uses_ou_v aba2,
2302: ce_bank_accounts ba2,
2303: ar_cash_receipt_history_all crh,
2304: ar_cash_receipts_all cr,

Line 2302: ce_bank_accounts ba2,

2298: ce_statement_reconcils_all rec,
2299: ce_bank_acct_uses_ou_v aba,
2300: ce_bank_accounts ba,
2301: ce_bank_acct_uses_ou_v aba2,
2302: ce_bank_accounts ba2,
2303: ar_cash_receipt_history_all crh,
2304: ar_cash_receipts_all cr,
2305: ar_receivable_applications_all ra,
2306: ar_payment_schedules_all ps

Line 2492: ce_bank_accounts ba,

2488: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2489: FROM gl_sets_of_books sob,
2490: ce_system_parameters sp,
2491: ce_statement_reconcils_all rec,
2492: ce_bank_accounts ba,
2493: ce_bank_acct_uses_ou_v aba,
2494: ap_payment_history_all aph,
2495: ap_checks_all c,
2496: ap_invoice_payments_all pay,

Line 2587: ce_bank_accounts ba,

2583: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2584: FROM gl_sets_of_books sob,
2585: ce_system_parameters sp,
2586: ce_statement_reconcils_all rec,
2587: ce_bank_accounts ba,
2588: ce_bank_acct_uses_ou_v aba,
2589: ar_cash_receipt_history_all crh,
2590: ar_cash_receipts_all cr,
2591: ar_receivable_applications_all ra,

Line 6116: ce_bank_accounts ba,

6112: select count(*)
6113: from ap_invoices ap,
6114: ap_invoice_payments aip,
6115: ap_checks_all ac,
6116: ce_bank_accounts ba,
6117: ce_bank_acct_uses_ou_v bau
6118: where ba.bank_account_num = CE_AUTO_BANK_MATCH.csl_bank_account_text
6119: and ba.bank_account_id = bau.bank_account_id
6120: and bau.AP_USE_ENABLE_FLAG ='Y'

Line 6936: from ce_bank_accts_gt_v --ce_BANK_ACCOUNTS_v

6932:
6933: IF (x_bank_account_id is not null)
6934: select ACCOUNT_OWNER_ORG_ID
6935: into p_le_id
6936: from ce_bank_accts_gt_v --ce_BANK_ACCOUNTS_v
6937: where BANK_ACCOUNT_ID = x_bank_account_id;
6938:
6939: select AMOUNT_TOLERANCE_OLD,
6940: PERCENT_TOLERANCE_OLD,

Line 9776: -- account_type CE_BANK_ACCOUNTS.account_classification%TYPE;

9772: statement_line_count NUMBER;
9773: i NUMBER;
9774: j NUMBER;
9775: rec_status NUMBER;
9776: -- account_type CE_BANK_ACCOUNTS.account_classification%TYPE;
9777: accounting_method_found NUMBER := 0;
9778: row_count NUMBER;
9779: ignore_trx_id NUMBER;
9780: ignore_trx_id2 NUMBER;

Line 10067: FROM ce_bank_accounts_v aba

10063: AND OU.ORGANIZATION_TYPE = 'BUSINESS_GROUP';
10064: */
10065: /* SELECT aba.account_classification
10066: INTO account_type
10067: FROM ce_bank_accounts_v aba
10068: WHERE aba.bank_account_id =
10069: CE_AUTO_BANK_MATCH.csh_bank_account_id;
10070: */
10071: -- IF account_type <> 'PAYROLL' THEN