APPS.AD_ZD_PREP dependencies on USER$

Line 132: where owner# =(select user# from sys.user$ where name = x_owner)

128: begin
129:
130: select count(obj#) into l_obj_cnt
131: from sys.obj$ o
132: where owner# =(select user# from sys.user$ where name = x_owner)
133: and o.NAME = x_name
134: and o.type# = 13 --13 = TYPE,
135: and o.subname is not null; --only for evloved type
136:

Line 177: where owner# =(select user# from sys.user$ where name = x_owner)

173: begin
174:
175: select count(obj#) into l_obj_cnt
176: from sys.obj$ o
177: where owner# =(select user# from sys.user$ where name = x_owner)
178: and o.NAME = x_name
179: and o.type# = 13;
180:
181: if(l_obj_cnt > 0 ) then

Line 201: where owner# =(select user# from sys.user$ where name = x_owner)

197: begin
198:
199: select count(obj#) into l_obj_cnt
200: from sys.obj$ o
201: where owner# =(select user# from sys.user$ where name = x_owner)
202: and o.NAME = x_name
203: and o.type# = 14; -- 14: TYPE BODY
204:
205: if(l_obj_cnt > 0 ) then

Line 1109: where owner# =(select user# from sys.user$ where name = referenced_owner)

1105: --
1106: and exists
1107: ( select 1
1108: from sys.obj$ o
1109: where owner# =(select user# from sys.user$ where name = referenced_owner)
1110: and o.NAME = referenced_name
1111: and o.type# = 13
1112: and o.subname is not null
1113: )

Line 1139: where owner# =(select user# from sys.user$ where name = d.referenced_owner)

1135: )
1136: and exists
1137: ( select 1
1138: from sys.obj$ o
1139: where owner# =(select user# from sys.user$ where name = d.referenced_owner)
1140: and o.name = d.referenced_name
1141: and o.type# = 13 --13 = TYPE,
1142: and o.subname is not null -- sstomar:
1143: -- This predicate is important becuase for evolved type more than

Line 1224: where owner# =(select user# from sys.user$ where name = referenced_owner)

1220: )
1221: and exists
1222: ( select 1
1223: from sys.obj$ o
1224: where owner# =(select user# from sys.user$ where name = referenced_owner)
1225: and o.NAME = referenced_name
1226: and o.type# = 13
1227: and o.subname is not null
1228: )

Line 1821: sys.user$ u

1817: -- Only Non-Editionable objects
1818: and do.type# not in (4,5,7,8,9,10,11,12,13,14,22,55,87)
1819: start with dep.p_obj# in (select o.obj#
1820: from sys.obj$ o,
1821: sys.user$ u
1822: where u.name = P_USER
1823: and u.user# = o.owner#
1824: and o.type# in (4,5,7,8,9,10,11,12,13,14,22,55,87) )
1825: connect by nocycle prior dep.d_obj# = dep.p_obj#;

Line 2101: sys.user$ u

2097: and du.username = fou.oracle_username
2098: and not exists
2099: (select u.name
2100: from sys.registry$ r,
2101: sys.user$ u
2102: where r.status in (1,3,5)
2103: and r.namespace = 'SERVER'
2104: and r.schema# = u.user#
2105: and u.name = du.username

Line 2110: sys.user$ u

2106: union
2107: select u.name
2108: from sys.registry$ r,
2109: sys.registry$schemas s,
2110: sys.user$ u
2111: where r.status in (1,3,5)
2112: and r.namespace = 'SERVER'
2113: and r.cid = s.cid
2114: and s.schema# = u.user#