DBA Data[Home] [Help]

APPS.CE_BANK_STATEMENT_LOADER dependencies on CE_BANK_BRANCHES_V

Line 255: FROM CE_BANK_BRANCHES_V --FROM AP_BANK_BRANCHES

251: AND bank_account_num = G_bank_account_num;
252: ELSIF G_bank_branch_id IS NOT NULL THEN
253: SELECT count(*)
254: INTO l_cnt
255: FROM CE_BANK_BRANCHES_V --FROM AP_BANK_BRANCHES
256: WHERE branch_party_id = G_bank_branch_id
257: AND bank_branch_name = G_bank_branch_name;
258: END IF;
259:

Line 334: CE_BANK_BRANCHES_V BB

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
338: BB.BANK_BRANCH_NAME = nvl(G_bank_branch_name,BB.BANK_BRANCH_NAME);

Line 1393: CE_BANK_BRANCHES_V BB --AP_BANK_BRANCHES BB

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
1397: --AND NVL(BA.account_type,'DUMMY') = 'INTERNAL'; --bug 3368534 added the AND condition.