APPS.XLA_00707_AAD_S_000007_PKG dependencies on FND_ORACLE_USERID

Line 138102: FROM fnd_oracle_userid

138098:
138099: -- select APPS owner
138100: SELECT oracle_username
138101: INTO p_apps_owner
138102: FROM fnd_oracle_userid
138103: WHERE read_only_flag = 'U'
138104: ;
138105:
138106: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 139400: FROM fnd_oracle_userid

139396:
139397: -- select APPS owner
139398: SELECT oracle_username
139399: INTO p_apps_owner
139400: FROM fnd_oracle_userid
139401: WHERE read_only_flag = 'U'
139402: ;
139403:
139404: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 140687: FROM fnd_oracle_userid

140683:
140684: -- select APPS owner
140685: SELECT oracle_username
140686: INTO p_apps_owner
140687: FROM fnd_oracle_userid
140688: WHERE read_only_flag = 'U'
140689: ;
140690:
140691: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 141981: FROM fnd_oracle_userid

141977:
141978: -- select APPS owner
141979: SELECT oracle_username
141980: INTO p_apps_owner
141981: FROM fnd_oracle_userid
141982: WHERE read_only_flag = 'U'
141983: ;
141984:
141985: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 143322: FROM fnd_oracle_userid

143318:
143319: -- select APPS owner
143320: SELECT oracle_username
143321: INTO p_apps_owner
143322: FROM fnd_oracle_userid
143323: WHERE read_only_flag = 'U'
143324: ;
143325:
143326: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 144932: FROM fnd_oracle_userid

144928:
144929: -- select APPS owner
144930: SELECT oracle_username
144931: INTO p_apps_owner
144932: FROM fnd_oracle_userid
144933: WHERE read_only_flag = 'U'
144934: ;
144935:
144936: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 146342: FROM fnd_oracle_userid

146338:
146339: -- select APPS owner
146340: SELECT oracle_username
146341: INTO p_apps_owner
146342: FROM fnd_oracle_userid
146343: WHERE read_only_flag = 'U'
146344: ;
146345:
146346: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 147913: FROM fnd_oracle_userid

147909:
147910: -- select APPS owner
147911: SELECT oracle_username
147912: INTO p_apps_owner
147913: FROM fnd_oracle_userid
147914: WHERE read_only_flag = 'U'
147915: ;
147916:
147917: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 149265: FROM fnd_oracle_userid

149261:
149262: -- select APPS owner
149263: SELECT oracle_username
149264: INTO p_apps_owner
149265: FROM fnd_oracle_userid
149266: WHERE read_only_flag = 'U'
149267: ;
149268:
149269: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 150501: FROM fnd_oracle_userid

150497:
150498: -- select APPS owner
150499: SELECT oracle_username
150500: INTO p_apps_owner
150501: FROM fnd_oracle_userid
150502: WHERE read_only_flag = 'U'
150503: ;
150504:
150505: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 151877: FROM fnd_oracle_userid

151873:
151874: -- select APPS owner
151875: SELECT oracle_username
151876: INTO p_apps_owner
151877: FROM fnd_oracle_userid
151878: WHERE read_only_flag = 'U'
151879: ;
151880:
151881: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 153287: FROM fnd_oracle_userid

153283:
153284: -- select APPS owner
153285: SELECT oracle_username
153286: INTO p_apps_owner
153287: FROM fnd_oracle_userid
153288: WHERE read_only_flag = 'U'
153289: ;
153290:
153291: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 154610: FROM fnd_oracle_userid

154606:
154607: -- select APPS owner
154608: SELECT oracle_username
154609: INTO p_apps_owner
154610: FROM fnd_oracle_userid
154611: WHERE read_only_flag = 'U'
154612: ;
154613:
154614: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 155846: FROM fnd_oracle_userid

155842:
155843: -- select APPS owner
155844: SELECT oracle_username
155845: INTO p_apps_owner
155846: FROM fnd_oracle_userid
155847: WHERE read_only_flag = 'U'
155848: ;
155849:
155850: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 157140: FROM fnd_oracle_userid

157136:
157137: -- select APPS owner
157138: SELECT oracle_username
157139: INTO p_apps_owner
157140: FROM fnd_oracle_userid
157141: WHERE read_only_flag = 'U'
157142: ;
157143:
157144: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 158399: FROM fnd_oracle_userid

158395:
158396: -- select APPS owner
158397: SELECT oracle_username
158398: INTO p_apps_owner
158399: FROM fnd_oracle_userid
158400: WHERE read_only_flag = 'U'
158401: ;
158402:
158403: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 159614: FROM fnd_oracle_userid

159610:
159611: -- select APPS owner
159612: SELECT oracle_username
159613: INTO p_apps_owner
159614: FROM fnd_oracle_userid
159615: WHERE read_only_flag = 'U'
159616: ;
159617:
159618: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 160937: FROM fnd_oracle_userid

160933:
160934: -- select APPS owner
160935: SELECT oracle_username
160936: INTO p_apps_owner
160937: FROM fnd_oracle_userid
160938: WHERE read_only_flag = 'U'
160939: ;
160940:
160941: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 162173: FROM fnd_oracle_userid

162169:
162170: -- select APPS owner
162171: SELECT oracle_username
162172: INTO p_apps_owner
162173: FROM fnd_oracle_userid
162174: WHERE read_only_flag = 'U'
162175: ;
162176:
162177: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 163484: FROM fnd_oracle_userid

163480:
163481: -- select APPS owner
163482: SELECT oracle_username
163483: INTO p_apps_owner
163484: FROM fnd_oracle_userid
163485: WHERE read_only_flag = 'U'
163486: ;
163487:
163488: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 164871: FROM fnd_oracle_userid

164867:
164868: -- select APPS owner
164869: SELECT oracle_username
164870: INTO p_apps_owner
164871: FROM fnd_oracle_userid
164872: WHERE read_only_flag = 'U'
164873: ;
164874:
164875: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 166442: FROM fnd_oracle_userid

166438:
166439: -- select APPS owner
166440: SELECT oracle_username
166441: INTO p_apps_owner
166442: FROM fnd_oracle_userid
166443: WHERE read_only_flag = 'U'
166444: ;
166445:
166446: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 167769: FROM fnd_oracle_userid

167765:
167766: -- select APPS owner
167767: SELECT oracle_username
167768: INTO p_apps_owner
167769: FROM fnd_oracle_userid
167770: WHERE read_only_flag = 'U'
167771: ;
167772:
167773: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 168996: FROM fnd_oracle_userid

168992:
168993: -- select APPS owner
168994: SELECT oracle_username
168995: INTO p_apps_owner
168996: FROM fnd_oracle_userid
168997: WHERE read_only_flag = 'U'
168998: ;
168999:
169000: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 170265: FROM fnd_oracle_userid

170261:
170262: -- select APPS owner
170263: SELECT oracle_username
170264: INTO p_apps_owner
170265: FROM fnd_oracle_userid
170266: WHERE read_only_flag = 'U'
170267: ;
170268:
170269: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 171559: FROM fnd_oracle_userid

171555:
171556: -- select APPS owner
171557: SELECT oracle_username
171558: INTO p_apps_owner
171559: FROM fnd_oracle_userid
171560: WHERE read_only_flag = 'U'
171561: ;
171562:
171563: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 172853: FROM fnd_oracle_userid

172849:
172850: -- select APPS owner
172851: SELECT oracle_username
172852: INTO p_apps_owner
172853: FROM fnd_oracle_userid
172854: WHERE read_only_flag = 'U'
172855: ;
172856:
172857: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 174089: FROM fnd_oracle_userid

174085:
174086: -- select APPS owner
174087: SELECT oracle_username
174088: INTO p_apps_owner
174089: FROM fnd_oracle_userid
174090: WHERE read_only_flag = 'U'
174091: ;
174092:
174093: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 175499: FROM fnd_oracle_userid

175495:
175496: -- select APPS owner
175497: SELECT oracle_username
175498: INTO p_apps_owner
175499: FROM fnd_oracle_userid
175500: WHERE read_only_flag = 'U'
175501: ;
175502:
175503: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 176909: FROM fnd_oracle_userid

176905:
176906: -- select APPS owner
176907: SELECT oracle_username
176908: INTO p_apps_owner
176909: FROM fnd_oracle_userid
176910: WHERE read_only_flag = 'U'
176911: ;
176912:
176913: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 178319: FROM fnd_oracle_userid

178315:
178316: -- select APPS owner
178317: SELECT oracle_username
178318: INTO p_apps_owner
178319: FROM fnd_oracle_userid
178320: WHERE read_only_flag = 'U'
178321: ;
178322:
178323: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 179729: FROM fnd_oracle_userid

179725:
179726: -- select APPS owner
179727: SELECT oracle_username
179728: INTO p_apps_owner
179729: FROM fnd_oracle_userid
179730: WHERE read_only_flag = 'U'
179731: ;
179732:
179733: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 181139: FROM fnd_oracle_userid

181135:
181136: -- select APPS owner
181137: SELECT oracle_username
181138: INTO p_apps_owner
181139: FROM fnd_oracle_userid
181140: WHERE read_only_flag = 'U'
181141: ;
181142:
181143: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 182549: FROM fnd_oracle_userid

182545:
182546: -- select APPS owner
182547: SELECT oracle_username
182548: INTO p_apps_owner
182549: FROM fnd_oracle_userid
182550: WHERE read_only_flag = 'U'
182551: ;
182552:
182553: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 183785: FROM fnd_oracle_userid

183781:
183782: -- select APPS owner
183783: SELECT oracle_username
183784: INTO p_apps_owner
183785: FROM fnd_oracle_userid
183786: WHERE read_only_flag = 'U'
183787: ;
183788:
183789: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 185195: FROM fnd_oracle_userid

185191:
185192: -- select APPS owner
185193: SELECT oracle_username
185194: INTO p_apps_owner
185195: FROM fnd_oracle_userid
185196: WHERE read_only_flag = 'U'
185197: ;
185198:
185199: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 186605: FROM fnd_oracle_userid

186601:
186602: -- select APPS owner
186603: SELECT oracle_username
186604: INTO p_apps_owner
186605: FROM fnd_oracle_userid
186606: WHERE read_only_flag = 'U'
186607: ;
186608:
186609: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 187928: FROM fnd_oracle_userid

187924:
187925: -- select APPS owner
187926: SELECT oracle_username
187927: INTO p_apps_owner
187928: FROM fnd_oracle_userid
187929: WHERE read_only_flag = 'U'
187930: ;
187931:
187932: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 189251: FROM fnd_oracle_userid

189247:
189248: -- select APPS owner
189249: SELECT oracle_username
189250: INTO p_apps_owner
189251: FROM fnd_oracle_userid
189252: WHERE read_only_flag = 'U'
189253: ;
189254:
189255: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 190516: FROM fnd_oracle_userid

190512:
190513: -- select APPS owner
190514: SELECT oracle_username
190515: INTO p_apps_owner
190516: FROM fnd_oracle_userid
190517: WHERE read_only_flag = 'U'
190518: ;
190519:
190520: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 191752: FROM fnd_oracle_userid

191748:
191749: -- select APPS owner
191750: SELECT oracle_username
191751: INTO p_apps_owner
191752: FROM fnd_oracle_userid
191753: WHERE read_only_flag = 'U'
191754: ;
191755:
191756: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 192988: FROM fnd_oracle_userid

192984:
192985: -- select APPS owner
192986: SELECT oracle_username
192987: INTO p_apps_owner
192988: FROM fnd_oracle_userid
192989: WHERE read_only_flag = 'U'
192990: ;
192991:
192992: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 194224: FROM fnd_oracle_userid

194220:
194221: -- select APPS owner
194222: SELECT oracle_username
194223: INTO p_apps_owner
194224: FROM fnd_oracle_userid
194225: WHERE read_only_flag = 'U'
194226: ;
194227:
194228: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 195435: FROM fnd_oracle_userid

195431:
195432: -- select APPS owner
195433: SELECT oracle_username
195434: INTO p_apps_owner
195435: FROM fnd_oracle_userid
195436: WHERE read_only_flag = 'U'
195437: ;
195438:
195439: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 196646: FROM fnd_oracle_userid

196642:
196643: -- select APPS owner
196644: SELECT oracle_username
196645: INTO p_apps_owner
196646: FROM fnd_oracle_userid
196647: WHERE read_only_flag = 'U'
196648: ;
196649:
196650: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 197857: FROM fnd_oracle_userid

197853:
197854: -- select APPS owner
197855: SELECT oracle_username
197856: INTO p_apps_owner
197857: FROM fnd_oracle_userid
197858: WHERE read_only_flag = 'U'
197859: ;
197860:
197861: IF (C_LEVEL_STATEMENT >= g_log_level) THEN