APPS.CN_CHK_PLAN_ELEMENT_PKG dependencies on CN_INTERVAL_TYPES

Line 2591: RETURN cn_interval_types.NAME%TYPE

2587: FUNCTION get_interval_name (
2588: p_interval_type_id NUMBER,
2589: p_org_id NUMBER
2590: )
2591: RETURN cn_interval_types.NAME%TYPE
2592: IS
2593: l_name cn_interval_types.NAME%TYPE;
2594: BEGIN
2595: SELECT NAME

Line 2593: l_name cn_interval_types.NAME%TYPE;

2589: p_org_id NUMBER
2590: )
2591: RETURN cn_interval_types.NAME%TYPE
2592: IS
2593: l_name cn_interval_types.NAME%TYPE;
2594: BEGIN
2595: SELECT NAME
2596: INTO l_name
2597: FROM cn_interval_types

Line 2597: FROM cn_interval_types

2593: l_name cn_interval_types.NAME%TYPE;
2594: BEGIN
2595: SELECT NAME
2596: INTO l_name
2597: FROM cn_interval_types
2598: WHERE interval_type_id = p_interval_type_id
2599: AND org_id = p_org_id;
2600:
2601: RETURN l_name;