VIEW: SYS.DBA_APPLICATION_ROLES

Source

View Text - Preformatted

select u.name, schema, package  from
user$ u, approle$ a
where  u.user# = a.role#

View Text - HTML Formatted

SELECT U.NAME
, SCHEMA
, PACKAGE FROM USER$ U
, APPROLE$ A WHERE U.USER# = A.ROLE#