APPS.FV_CCR_UTIL_PVT dependencies on CE_BANK_BRANCHES_V

Line 429: FROM ce_bank_branches_v

425: l_bank_name VARCHAR2(60);
426: l_module_name VARCHAR2(60);
427: CURSOR bank_branch_csr(p_routing VARCHAR2) IS
428: SELECT branch_party_id, bank_name, bank_branch_name
429: FROM ce_bank_branches_v
430: WHERE branch_number = p_routing
431: AND branch_number IS NOT NULL;
432: BEGIN
433:

Line 441: l_routing_num FROM ce_bank_branches_v

437: IF(nvl(p_bank_branch_id,0)<>0) THEN
438: BEGIN
439: SELECT bank_name,bank_branch_name,branch_number
440: INTO l_bank_name,l_bank_branch_name,
441: l_routing_num FROM ce_bank_branches_v
442: WHERE branch_party_id = p_bank_branch_id;
443: EXCEPTION
444: WHEN OTHERS THEN
445: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,