DBA Data[Home] [Help]

APPS.FTE_UTIL_PKG dependencies on FND_LOOKUP_VALUES_VL

Line 213: FROM fnd_lookup_values_vl

209:
210: -- First check with LOOKUP_CODE
211: BEGIN
212: SELECT lookup_code INTO l_code
213: FROM fnd_lookup_values_vl
214: WHERE lookup_type = p_lookup_type
215: AND lookup_code = p_value;
216: EXCEPTION
217: WHEN NO_DATA_FOUND THEN

Line 222: FROM fnd_lookup_values_vl

218: BEGIN
219: -- If the given value can't be found as LOOKUP_CODE
220: -- try with 'like MEANING%'
221: SELECT lookup_code INTO l_code
222: FROM fnd_lookup_values_vl
223: WHERE lookup_type = p_lookup_type
224: AND meaning like p_value;
225: EXCEPTION
226: WHEN NO_DATA_FOUND THEN