DBA Data[Home] [Help]

APPS.CN_CHK_PLAN_ELEMENT_PKG dependencies on CN_CREDIT_TYPES

Line 2567: RETURN cn_credit_types.NAME%TYPE

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

Line 2569: l_c_type cn_credit_types.NAME%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
2572: INTO l_c_type
2573: FROM cn_credit_types

Line 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