VIEW: SYS.KU$_PROCOBJACT_VIEW

Source

View Text - Preformatted

select distinct p.package, p.schema
  FROM  sys.exppkgact$ p
  WHERE (SYS_CONTEXT('USERENV','CURRENT_USERID') = 0 OR
         SYS_CONTEXT('USERENV','SESSION_USER') = p.schema OR
                EXISTS ( SELECT * FROM sys.session_roles
                        WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT DISTINCT P.PACKAGE
, P.SCHEMA
FROM SYS.EXPPKGACT$ P
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 0 OR SYS_CONTEXT('USERENV'
, 'SESSION_USER') = P.SCHEMA OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))