48: ,C_ACCOUNT_NAME_DSP
49: ,C_ACCOUNT_NUMBER_DSP
50: ,C_BANK_CURR_DSP
51: FROM
52: CE_BANK_BRANCHES_V ABB,
53: CE_BANK_ACCTS_GT_V ABA
54: WHERE ABA.BANK_ACCOUNT_ID = P_BANK_ACCOUNT_ID
55: AND ABB.BRANCH_PARTY_ID = ABA.BANK_BRANCH_ID;
56: EXCEPTION