APPS.ASG_COMPILE_PKG dependencies on OBJ$

Line 50: from sys.obj$ o, sys.user$ u

46: 44, 'CONTEXT', 47, 'RESOURCE PLAN',
47: 48, 'CONSUMER GROUP',
48: 51, 'SUBSCRIPTION', 52, 'LOCATION',
49: 'UNDEFINED') object_type
50: from sys.obj$ o, sys.user$ u
51: where o.owner# = u.user#
52: and u.name = schema_name
53:
54: and o.status <> 1 /* not valid status */

Line 195: from sys.obj$ o

191: 44, 'CONTEXT', 47, 'RESOURCE PLAN',
192: 48, 'CONSUMER GROUP',
193: 51, 'SUBSCRIPTION', 52, 'LOCATION',
194: 'UNDEFINED') object_type
195: from sys.obj$ o
196: where o.owner# = userenv('SCHEMAID')
197: and o.status <> 1 /* not valid status */
198: -- and o.name like '%%'
199: and o.type# not in (28, 29, 30,12) /* exclude Java stuff for now + trigger*/