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);