APPS.AD_ZD_PARALLEL_EXEC dependencies on DBA_INVALID_OBJECTS

Line 217: from dba_invalid_objects

213: C_MODULE varchar2(80) := c_package||'recompile_objects';
214: begin
215: for obj in
216: ( select owner, object_name
217: from dba_invalid_objects
218: where object_name like 'AD_ZD%'
219: and object_type like 'PACKAGE%' )
220: loop
221: log(c_module, 'STATEMENT', 'Recompiling '||obj.owner||'.'||obj.object_name);