DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on ALL_OBJECTS

Line 3358: FROM all_objects

3354: p_report out nocopy varchar2)
3355: is
3356: CURSOR c_dom IS
3357: SELECT status, owner
3358: FROM all_objects
3359: WHERE object_name = 'XMLDOM'
3360: AND object_type = 'PACKAGE'
3361: AND (owner in ('SYS', 'SYSTEM') OR owner = g_qowner)
3362: UNION

Line 3370: FROM all_objects

3366: AND object_type = 'PACKAGE';
3367:
3368: CURSOR c_java IS
3369: SELECT object_name, status, owner
3370: FROM all_objects
3371: WHERE object_type = 'JAVA RESOURCE'
3372: AND object_name like '%xmlparser%'
3373: AND (owner in ('SYS', 'SYSTEM') OR owner = g_qowner)
3374: UNION