APPS.OKC_TERMS_UTIL_PVT dependencies on FND_FLEX_VALUES_VL

Line 2543: l_name FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE := null;

2539: p_FLEX_VALUE_ID IN VARCHAR2 )
2540: RETURN VARCHAR2 IS
2541:
2542: --l_name varchar2(80) := null;
2543: l_name FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE := null;
2544:
2545: cursor flex_value_vl_csr(l_value_set_id NUMBER, l_flex_value_id VARCHAR2) is
2546: select value.flex_value
2547: from fnd_flex_values_vl value,

Line 2547: from fnd_flex_values_vl value,

2543: l_name FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE := null;
2544:
2545: cursor flex_value_vl_csr(l_value_set_id NUMBER, l_flex_value_id VARCHAR2) is
2546: select value.flex_value
2547: from fnd_flex_values_vl value,
2548: fnd_flex_value_sets val_set
2549: where
2550: value.FLEX_VALUE_SET_ID = val_set.FLEX_VALUE_SET_ID
2551: and val_set.flex_value_set_id = l_value_set_id