DBA Data[Home] [Help]

APPS.IBY_EXT_BANKACCT_PUB dependencies on CE_BANK_BRANCHES_V

Line 1983: FROM CE_BANK_BRANCHES_V

1979:
1980: -- get bank and branch numbers
1981: CURSOR c_bank_branch (p_bank_id NUMBER, p_branch_id NUMBER)IS
1982: SELECT BANK_NUMBER, BRANCH_NUMBER
1983: FROM CE_BANK_BRANCHES_V
1984: WHERE BANK_PARTY_ID = p_bank_id
1985: AND BRANCH_PARTY_ID = p_branch_id;
1986:
1987: CURSOR c_supplier(p_acct_id NUMBER) IS

Line 3920: from ce_bank_branches_v ce_bank

3916: select ce_bank.bank_party_id as bank_id,
3917: ce_bank.bank_home_country as country,
3918: ce_bank.bank_name,
3919: ce_bank.bank_number
3920: from ce_bank_branches_v ce_bank
3921: where ce_bank.branch_party_id=p_branch_id;
3922:
3923: /*
3924: SELECT hz_bank.party_id AS bank_id,