DBA Data[Home] [Help]

APPS.WSH_OTM_RIQ_XML dependencies on FND_LOOKUP_VALUES

Line 1086: -- fixed in R12, select from fnd_lookup_values not from oe_lookups

1082: l_return_status VARCHAR2(1);
1083: l_debug_on BOOLEAN;
1084: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Validate_Look_Up_NoCase';
1085:
1086: -- fixed in R12, select from fnd_lookup_values not from oe_lookups
1087: -- cause WSH_SERVICE_LEVELS, WSH_MODE_OF_TRANSPORT are not defined in oe_lookup
1088:
1089: CURSOR c_check_lookup(c_lookup_code IN VARCHAR2)
1090: IS

Line 1092: FROM fnd_lookup_values

1088:
1089: CURSOR c_check_lookup(c_lookup_code IN VARCHAR2)
1090: IS
1091: SELECT lookup_code
1092: FROM fnd_lookup_values
1093: WHERE lookup_type = p_lookup_type
1094: AND UPPER(lookup_code) = UPPER(c_lookup_code)
1095: AND nvl(start_date_active,SYSDATE) <= SYSDATE
1096: AND nvl(end_date_active,SYSDATE) >= SYSDATE