APPS.XTR_NOTIONAL_BANK_ACCOUNTS dependencies on DUAL

Line 191: FROM DUAL;

187: (rpad
188: (l_new_acct_number,20, l_dummy_char),
189: 1,19)||l_counter)
190: INTO l_new_acct_number
191: FROM DUAL;
192: ELSIF ((l_counter >= 10) AND (l_counter < 100)) THEN
193: SELECT REPLACE(
194: rpad(
195: l_new_acct_number, 20, l_dummy_char),

Line 203: FROM DUAL;

199: (rpad
200: (l_new_acct_number,20, l_dummy_char),
201: 1,18)||l_counter)
202: INTO l_new_acct_number
203: FROM DUAL;
204: ELSIF ((l_counter >=100) AND (l_counter < 1000)) THEN
205: SELECT REPLACE(
206: rpad(
207: l_new_acct_number, 20, l_dummy_char),

Line 215: FROM DUAL;

211: (rpad
212: (l_new_acct_number,20, l_dummy_char),
213: 1,17)||l_counter)
214: INTO l_new_acct_number
215: FROM DUAL;
216: ELSIF ((l_counter >=1000) AND (l_counter < 10000)) THEN
217: SELECT REPLACE(
218: rpad(
219: l_new_acct_number, 20, l_dummy_char),

Line 227: FROM DUAL;

223: (rpad
224: (l_new_acct_number,20, l_dummy_char),
225: 1,16)||l_counter)
226: INTO l_new_acct_number
227: FROM DUAL;
228: ELSIF ((l_counter >=10000) AND (l_counter <100000)) THEN
229: SELECT REPLACE(
230: rpad(
231: l_new_acct_number, 20, l_dummy_char),

Line 239: FROM DUAL;

235: (rpad
236: (l_new_acct_number,20, l_dummy_char),
237: 1,15)||l_counter)
238: INTO l_new_acct_number
239: FROM DUAL;
240: ELSIF ((l_counter >=100000) AND
241: (l_counter <1000000)) THEN
242: SELECT REPLACE(
243: rpad(

Line 252: FROM DUAL;

248: (rpad
249: (l_new_acct_number,20, l_dummy_char),
250: 1,14)||l_counter)
251: INTO l_new_acct_number
252: FROM DUAL;
253: END IF;
254: l_counter := l_counter + 1;
255: END IF;
256: EXIT WHEN ACCT_NUMBER_EXISTS%NOTFOUND;