APPS.FV_CCR_UTIL_PVT dependencies on CE_BANK_BRANCHES_V

Line 383: FROM ce_bank_branches_v

379: l_bank_name VARCHAR2(60);
380: l_module_name VARCHAR2(60);
381: CURSOR bank_branch_csr(p_routing VARCHAR2) IS
382: SELECT branch_party_id, bank_name, bank_branch_name
383: FROM ce_bank_branches_v
384: WHERE branch_number = p_routing
385: AND branch_number IS NOT NULL;
386: BEGIN
387:

Line 395: l_routing_num FROM ce_bank_branches_v

391: IF(nvl(p_bank_branch_id,0)<>0) THEN
392: BEGIN
393: SELECT bank_name,bank_branch_name,branch_number
394: INTO l_bank_name,l_bank_branch_name,
395: l_routing_num FROM ce_bank_branches_v
396: WHERE branch_party_id = p_bank_branch_id;
397: EXCEPTION
398: WHEN OTHERS THEN
399: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,