APPS.IEX_WEBDIR_PVT dependencies on DUAL

Line 59: FROM SYS.DUAL;

55: AND CGI_SERVER = l_web_search_rec.cgi_server;
56:
57: CURSOR c_query_seq IS
58: SELECT IEX_QUERY_STRINGS_S.NEXTVAL
59: FROM SYS.DUAL;
60:
61: BEGIN
62: -- Standard begin of API savepoint
63: SAVEPOINT Create_WebAssist_PVT;

Line 133: FROM SYS.DUAL;

129: IF c_web_assist%NOTFOUND THEN
130: DECLARE
131: CURSOR c_web_assist_seq IS
132: SELECT IEX_WEB_ASSISTS_S.NEXTVAL
133: FROM SYS.DUAL;
134: BEGIN
135: CLOSE c_web_assist;
136: OPEN c_web_assist_seq;
137: FETCH c_web_assist_seq INTO l_web_assist_id;

Line 154: FROM SYS.DUAL;

150: IF c_web_search%NOTFOUND THEN
151: DECLARE
152: CURSOR c_search_seq IS
153: SELECT IEX_WEB_SEARCHES_S.NEXTVAL
154: FROM SYS.DUAL;
155: BEGIN
156: CLOSE c_web_search;
157: OPEN c_search_seq;
158: FETCH c_search_seq INTO l_search_id;