APPS.WSH_XC_UTIL dependencies on FND_LOOKUP_VALUES_VL

Line 252: FROM fnd_lookup_values_vl

248:
249: -- cursor to validate logging_entity
250: CURSOR C2 (c_logging_entity VARCHAR2) IS
251: SELECT lookup_code
252: FROM fnd_lookup_values_vl
253: WHERE lookup_type = 'LOGGING_ENTITY' AND
254: lookup_code = c_logging_entity AND
255: enabled_flag = 'Y' AND
256: (sysdate BETWEEN NVL(start_date_active,sysdate) AND

Line 3105: select meaning from fnd_lookup_values_vl

3101: p_lookup_type IN VARCHAR2 ) return VARCHAR2
3102: is
3103:
3104: CURSOR C1(c_lookup_code VARCHAR2, c_lookup_type VARCHAR2) is
3105: select meaning from fnd_lookup_values_vl
3106: where lookup_code = c_lookup_code and
3107: lookup_type = c_lookup_type;
3108:
3109: l_lookup_meaning VARCHAR2(80) := NULL;