APPS.OZF_QUOTA_ALLOCATIONS_PVT dependencies on OZF_THRESHOLDS_ALL_VL

Line 113: SELECT NAME FROM ozf_thresholds_all_vl WHERE threshold_id = p_id;

109:
110:
111: FUNCTION get_threshold_name(p_threshold_id IN NUMBER )RETURN VARCHAR2 IS
112: CURSOR c_threshold_name (p_id NUMBER) IS
113: SELECT NAME FROM ozf_thresholds_all_vl WHERE threshold_id = p_id;
114: l_threshold_name ozf_thresholds_all_vl.NAME%TYPE;
115: BEGIN
116: OPEN c_threshold_name(p_threshold_id);
117: FETCH c_threshold_name INTO l_threshold_name;

Line 114: l_threshold_name ozf_thresholds_all_vl.NAME%TYPE;

110:
111: FUNCTION get_threshold_name(p_threshold_id IN NUMBER )RETURN VARCHAR2 IS
112: CURSOR c_threshold_name (p_id NUMBER) IS
113: SELECT NAME FROM ozf_thresholds_all_vl WHERE threshold_id = p_id;
114: l_threshold_name ozf_thresholds_all_vl.NAME%TYPE;
115: BEGIN
116: OPEN c_threshold_name(p_threshold_id);
117: FETCH c_threshold_name INTO l_threshold_name;
118: CLOSE c_threshold_name;