DBA Data[Home] [Help]

APPS.IEX_WEBDIR_PVT dependencies on IEX_WEB_SEARCHES_S

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;