APPS.CE_BANK_STATEMENT_LOADER dependencies on CE_BANK_BRANCHES_V

Line 416: FROM CE_BANK_BRANCHES_V --FROM AP_BANK_BRANCHES

412: AND bank_account_num = G_bank_account_num;
413: ELSIF G_bank_branch_id IS NOT NULL THEN
414: SELECT count(*)
415: INTO l_cnt
416: FROM CE_BANK_BRANCHES_V --FROM AP_BANK_BRANCHES
417: WHERE branch_party_id = G_bank_branch_id
418: AND bank_branch_name = G_bank_branch_name;
419: END IF;
420:

Line 495: CE_BANK_BRANCHES_V BB

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

Line 1532: CE_BANK_BRANCHES_V BB

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
1536: AND NVL(G_Bank_Branch_id, BA.Bank_branch_id) = BA.bank_branch_id -- Bug 8209720