APPS.IEB_SYNC_SERVER dependencies on DUAL

Line 200: select IEB_WB_SERVER_S1.NEXTVAL into l_wbsvr_id from sys.dual;

196: l_ieo_svr_id := NULL;
197: end;
198:
199: if ( l_wbsvr_id IS NULL ) then
200: select IEB_WB_SERVER_S1.NEXTVAL into l_wbsvr_id from sys.dual;
201: insert into IEB_WB_SERVERS
202: (wbsvr_id,
203: created_by,
204: creation_date,

Line 328: select IEB_SVC_CATS_S1.NEXTVAL into l_wbsc_id from sys.dual;

324: begin
325: x_return_status := fnd_api.g_ret_sts_success;
326:
327: for c1_rec in c1 loop
328: select IEB_SVC_CATS_S1.NEXTVAL into l_wbsc_id from sys.dual;
329: if c1_rec.depth = 0 then
330: l_parent_id := NULL;
331: l_parent_id_ib := l_wbsc_id;
332: l_parent_id_ob := l_wbsc_id;

Line 513: select IEB_SVC_CATS_S1.NEXTVAL into l_wbsc_id from sys.dual;

509: -- commit;
510:
511: if (sql%notfound) then
512:
513: select IEB_SVC_CATS_S1.NEXTVAL into l_wbsc_id from sys.dual;
514: if c1_rec2.depth = 0 then
515: l_parent_id := NULL;
516: l_root_id_ib := l_wbsc_id;
517: l_root_id_ob := l_wbsc_id;