355: EXCEPTION
356: WHEN NO_DATA_FOUND THEN
357: l_return := FALSE;
358: END;
359: ELSIF UPPER(l_lookup_table) = 'SO_LOOKUPS' THEN
360: BEGIN
361: SELECT 'Y' INTO l_dummy
362: FROM SO_LOOKUPS
363: WHERE LOOKUP_TYPE = l_lookup_type
358: END;
359: ELSIF UPPER(l_lookup_table) = 'SO_LOOKUPS' THEN
360: BEGIN
361: SELECT 'Y' INTO l_dummy
362: FROM SO_LOOKUPS
363: WHERE LOOKUP_TYPE = l_lookup_type
364: AND LOOKUP_CODE = l_lookup_code
365: AND (ENABLED_FLAG = 'Y' AND
366: TRUNC(SYSDATE) BETWEEN