The following lines contain the word 'select', 'insert', 'update' or 'delete':
select object_name, object_type from dba_objects
where owner = upper(compile_schema.in_schema)
and status = 'INVALID'
and object_type = 'PACKAGE';
select object_name, object_type from dba_objects
where owner = upper(compile_schema.in_schema)
and status = 'INVALID'
and object_type = 'VIEW';
select object_name, object_type from dba_objects
where owner = upper(compile_schema.in_schema)
and status = 'INVALID'
order by decode(object_type,'PACKAGE',1,'VIEW',2,'PACKAGE BODY',4,3);