SYSTEM.AD_PARALLEL_COMPILE_PKG dependencies on OBJ$

Line 72: sys.obj$ o,

68: 0,
69: 'INVALID',
70: o.status
71: from
72: sys.obj$ o,
73: sys.user$ u
74: where
75: u.user# = o.owner#
76: and u.name = sName

Line 110: sys.obj$ o,

106: 0,
107: 'INVALID',
108: o.status
109: from
110: sys.obj$ o,
111: sys.user$ u
112: where
113: u.user# = o.owner#
114: and u.name = sName

Line 140: sys.obj$ o,

136: where obj# in
137: (select /*+ leading(t) use_nl(o) */
138: o.obj#
139: from
140: sys.obj$ o,
141: sys.trigger$ t,
142: sys.user$ u
143: where
144: u.user# = o.owner#

Line 196: sys.obj$ o,

192: where obj# in
193: (select
194: o.obj#
195: from
196: sys.obj$ o,
197: sys.error$ e,
198: sys.user$ u
199: where
200: u.name = sName

Line 218: from ad_parallel_compile pc, sys.obj$ o

214: update ad_parallel_compile
215: set status = 'VALID'
216: where obj# in
217: (select pc.obj#
218: from ad_parallel_compile pc, sys.obj$ o
219: where pc.obj# = o.obj#
220: and pc.sys_stat <> o.status);
221: end update_done;
222: