2563: --| ---------------------------------------------------------------------+
2564: FUNCTION get_credit_type (
2565: p_credit_type_id NUMBER
2566: )
2567: RETURN cn_credit_types.NAME%TYPE
2568: IS
2569: l_c_type cn_credit_types.NAME%TYPE;
2570: BEGIN
2571: SELECT NAME
2565: p_credit_type_id NUMBER
2566: )
2567: RETURN cn_credit_types.NAME%TYPE
2568: IS
2569: l_c_type cn_credit_types.NAME%TYPE;
2570: BEGIN
2571: SELECT NAME
2572: INTO l_c_type
2573: FROM cn_credit_types
2569: l_c_type cn_credit_types.NAME%TYPE;
2570: BEGIN
2571: SELECT NAME
2572: INTO l_c_type
2573: FROM cn_credit_types
2574: WHERE credit_type_id = p_credit_type_id;
2575:
2576: RETURN l_c_type;
2577: EXCEPTION