The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT name
INTO x_dimension_name
FROM cn_dimensions
WHERE dimension_id = x_dimension_id ;
SELECT cn_objects_s.nextval
INTO x_object_id
FROM sys.dual ;
SELECT count(name)
INTO x_count
FROM cn_obj_tables_v
WHERE name = x_name
AND schema = x_schema ;
SELECT count(name)
INTO x_count
FROM cn_obj_columns_v
WHERE name = x_name
AND table_id = x_table_id ;