APPS.CE_BANK_STATEMENT_LOADER dependencies on CE_BANK_ACCOUNTS

Line 249: FROM CE_BANK_ACCOUNTS --FROM AP_BANK_ACCOUNTS_ALL

245: --
246: IF G_bank_account_id IS NOT NULL THEN
247: SELECT count(*)
248: INTO l_cnt
249: FROM CE_BANK_ACCOUNTS --FROM AP_BANK_ACCOUNTS_ALL
250: WHERE bank_account_id = G_bank_account_id
251: AND bank_account_num = G_bank_account_num;
252: ELSIF G_bank_branch_id IS NOT NULL THEN
253: SELECT count(*)

Line 333: FROM CE_BANK_ACCOUNTS BA,

329:
330: BEGIN
331: SELECT count(1)
332: INTO l_rec_cnt
333: FROM CE_BANK_ACCOUNTS BA,
334: CE_BANK_BRANCHES_V BB
335: WHERE BA.ACCOUNT_CLASSIFICATION = 'SUBSIDIARY' AND
336: BB.branch_party_id = BA.bank_branch_id AND
337: BA.bank_account_num = G_bank_account_num AND

Line 1392: FROM CE_BANK_ACCOUNTS BA, --FROM AP_BANK_ACCOUNTS_ALL BA,

1388: BB.branch_party_id,
1389: BA.bank_account_id,
1390: BA.currency_code
1391: --BA.org_id
1392: FROM CE_BANK_ACCOUNTS BA, --FROM AP_BANK_ACCOUNTS_ALL BA,
1393: CE_BANK_BRANCHES_V BB --AP_BANK_BRANCHES BB
1394: WHERE BB.branch_party_id = BA.bank_branch_id
1395: AND BA.bank_account_num = G_bank_account_num
1396: AND NVL(BA.account_classification,'DUMMY') = 'INTERNAL'; --bug 6511845

Line 1411: FROM CE_BANK_ACCOUNTS --FROM AP_BANK_ACCOUNTS_ALL

1407: END IF;
1408:
1409: SELECT count(*)
1410: INTO l_cnt
1411: FROM CE_BANK_ACCOUNTS --FROM AP_BANK_ACCOUNTS_ALL
1412: WHERE BANK_ACCOUNT_NUM = G_bank_account_num
1413: and NVL(ACCOUNT_CLASSIFICATION,'DUMMY') = 'INTERNAL'; -- Bug 6511845
1414: --and NVL(ACCOUNT_TYPE,'DUMMY') = 'INTERNAL'; -- Bug 3368534 added this line.
1415: