APPS.IEX_WEBDIR_PVT dependencies on IEX_WEB_SEARCHES

Line 53: FROM IEX_WEB_SEARCHES

49: AND PROXY_PORT = l_web_assist_rec.proxy_port;
50:
51: CURSOR c_web_search IS
52: SELECT SEARCH_ID
53: FROM IEX_WEB_SEARCHES
54: WHERE SEARCH_URL = l_web_search_rec.search_url
55: AND CGI_SERVER = l_web_search_rec.cgi_server;
56:
57: CURSOR c_query_seq IS

Line 153: SELECT IEX_WEB_SEARCHES_S.NEXTVAL

149: FETCH c_web_search INTO l_search_id;
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;