DBA Data[Home] [Help]

APPS.IBY_EXT_BANKACCT_PUB dependencies on CE_BANK_BRANCHES_V

Line 2328: FROM CE_BANK_BRANCHES_V

2324:
2325: -- get bank and branch numbers
2326: CURSOR c_bank_branch (p_bank_id NUMBER, p_branch_id NUMBER)IS
2327: SELECT BANK_NUMBER, BRANCH_NUMBER
2328: FROM CE_BANK_BRANCHES_V
2329: WHERE BANK_PARTY_ID = p_bank_id
2330: AND BRANCH_PARTY_ID = p_branch_id;
2331:
2332: CURSOR c_supplier(p_acct_id NUMBER) IS

Line 4742: from ce_bank_branches_v ce_bank

4738: select ce_bank.bank_party_id as bank_id,
4739: ce_bank.bank_home_country as country,
4740: ce_bank.bank_name,
4741: ce_bank.bank_number
4742: from ce_bank_branches_v ce_bank
4743: where ce_bank.branch_party_id=p_branch_id;
4744:
4745: /*
4746: SELECT hz_bank.party_id AS bank_id,