APPS.IEX_WEBDIR_PVT dependencies on IEX_WEB_ASSISTS

Line 47: FROM IEX_WEB_ASSISTS

43: l_login_id NUMBER;
44:
45: CURSOR c_web_assist IS
46: SELECT WEB_ASSIST_ID
47: FROM IEX_WEB_ASSISTS
48: WHERE PROXY_HOST = l_web_assist_rec.proxy_host
49: AND PROXY_PORT = l_web_assist_rec.proxy_port;
50:
51: CURSOR c_web_search IS

Line 132: SELECT IEX_WEB_ASSISTS_S.NEXTVAL

128: FETCH c_web_assist INTO l_web_assist_id;
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;