211: EXCEPTION
212: WHEN NO_DATA_FOUND THEN
213: l_return := FALSE;
214: END;
215: ELSIF UPPER(l_lookup_table) = 'SO_LOOKUPS' THEN
216: BEGIN
217: SELECT 'Y' INTO l_dummy
218: FROM SO_LOOKUPS
219: WHERE LOOKUP_TYPE = l_lookup_type
214: END;
215: ELSIF UPPER(l_lookup_table) = 'SO_LOOKUPS' THEN
216: BEGIN
217: SELECT 'Y' INTO l_dummy
218: FROM SO_LOOKUPS
219: WHERE LOOKUP_TYPE = l_lookup_type
220: AND LOOKUP_CODE = l_lookup_code
221: AND (ENABLED_FLAG = 'Y' AND
222: TRUNC(SYSDATE) BETWEEN