DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on ALL_OBJECTS

Line 3709: FROM all_objects

3705: p_report out nocopy varchar2)
3706: is
3707: CURSOR c_dom IS
3708: SELECT status, owner
3709: FROM all_objects
3710: WHERE object_name = 'XMLDOM'
3711: AND object_type = 'PACKAGE'
3712: AND (owner in ('SYS', 'SYSTEM') OR owner = g_qowner)
3713: UNION

Line 3721: FROM all_objects

3717: AND object_type = 'PACKAGE';
3718:
3719: CURSOR c_java IS
3720: SELECT object_name, status, owner
3721: FROM all_objects
3722: WHERE object_type = 'JAVA RESOURCE'
3723: AND object_name like '%xmlparser%'
3724: AND (owner in ('SYS', 'SYSTEM') OR owner = g_qowner)
3725: UNION