APPS.CE_BANK_STATEMENT_LOADER dependencies on CE_BANK_ACCOUNTS

Line 410: FROM CE_BANK_ACCOUNTS --FROM AP_BANK_ACCOUNTS_ALL

406: --
407: IF G_bank_account_id IS NOT NULL THEN
408: SELECT count(*)
409: INTO l_cnt
410: FROM CE_BANK_ACCOUNTS --FROM AP_BANK_ACCOUNTS_ALL
411: WHERE bank_account_id = G_bank_account_id
412: AND bank_account_num = G_bank_account_num;
413: ELSIF G_bank_branch_id IS NOT NULL THEN
414: SELECT count(*)

Line 494: FROM CE_BANK_ACCOUNTS BA,

490:
491: BEGIN
492: SELECT count(1)
493: INTO l_rec_cnt
494: FROM CE_BANK_ACCOUNTS BA,
495: CE_BANK_BRANCHES_V BB
496: WHERE BA.ACCOUNT_CLASSIFICATION = 'SUBSIDIARY' AND
497: BB.branch_party_id = BA.bank_branch_id AND
498: BA.bank_account_num = G_bank_account_num AND

Line 1531: FROM CE_BANK_ACCOUNTS BA,

1527: BB.bank_branch_name,
1528: BB.branch_party_id,
1529: BA.bank_account_id,
1530: BA.currency_code
1531: FROM CE_BANK_ACCOUNTS BA,
1532: CE_BANK_BRANCHES_V BB
1533: WHERE BB.branch_party_id = BA.bank_branch_id
1534: AND BA.bank_account_num = G_bank_account_num
1535: AND NVL(BA.account_classification,'DUMMY') = 'INTERNAL' -- Bug 6511845

Line 1563: FROM CE_BANK_ACCOUNTS

1559: ||',acct_id='||G_bank_account_id);
1560:
1561: SELECT count(*)
1562: INTO l_cnt
1563: FROM CE_BANK_ACCOUNTS
1564: WHERE BANK_ACCOUNT_NUM = G_bank_account_num
1565: AND NVL(ACCOUNT_CLASSIFICATION,'DUMMY') = 'INTERNAL' -- Bug 6511845
1566: AND NVL(G_Bank_Branch_id,Bank_branch_id) = Bank_branch_id -- Bug 8209720
1567: AND NVL(G_bank_account_id, bank_account_id) = bank_account_id -- Bug 8209720