APPS.FND_FLEX_TYPES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 9

   SELECT NULL INTO dummy
     FROM fnd_lookups
     WHERE lookup_type = typ
     AND lookup_code = code
     AND enabled_flag = 'Y'
     AND ( (start_date_active IS NULL)
           OR (start_date_active <= SYSDATE))
     AND ( (end_date_active IS NULL)
           OR (end_date_active >= SYSDATE));

Line: 68

	SELECT lookup_code, Decode(language, 'US', 1, 2) pri
	  FROM fnd_lookup_values
	  WHERE meaning = descr
	  AND lookup_type = typ
	  ORDER BY pri;