APPS.OKC_TERMS_UTIL_PVT dependencies on FND_FLEX_VALUES_VL

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

2581: p_FLEX_VALUE_ID IN VARCHAR2 )
2582: RETURN VARCHAR2 IS
2583:
2584: --l_name varchar2(80) := null;
2585: l_name FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE := null;
2586:
2587: cursor flex_value_vl_csr(l_value_set_id NUMBER, l_flex_value_id VARCHAR2) is
2588: select value.flex_value
2589: from fnd_flex_values_vl value,

Line 2589: from fnd_flex_values_vl value,

2585: l_name FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE := null;
2586:
2587: cursor flex_value_vl_csr(l_value_set_id NUMBER, l_flex_value_id VARCHAR2) is
2588: select value.flex_value
2589: from fnd_flex_values_vl value,
2590: fnd_flex_value_sets val_set
2591: where
2592: value.FLEX_VALUE_SET_ID = val_set.FLEX_VALUE_SET_ID
2593: and val_set.flex_value_set_id = l_value_set_id