DBA Data[Home] [Help]

APPS.IGI_SLS_SECURITY_PKG dependencies on DBA_OBJECTS

Line 117: FROM dba_objects

113: AND read_only_flag = p_read_only_flag;
114:
115: CURSOR c_chk_install (p_schema_name IN VARCHAR2) IS
116: SELECT COUNT(*)
117: FROM dba_objects
118: WHERE object_type IN ('PACKAGE', 'PACKAGE BODY')
119: AND object_name IN ('APPS_DDL', 'APPS_ARRAY_DDL')
120: AND status = 'VALID'
121: AND owner = UPPER (p_schema_name);