APPS.JTF_TTY_GEO_WEBADI_INT_PKG dependencies on JTF_TTY_GEO_INT_S

Line 285: select jtf_tty_geo_int_s.nextval into SEQ from dual;

281: delete from JTF_TTY_GEO_WEBADI_INTERFACE
282: where user_id = p_userid
283: and sysdate - creation_date >2;
284:
285: select jtf_tty_geo_int_s.nextval into SEQ from dual;
286:
287: select count(*) into id from JTF_TTY_GEO_WEBADI_INTERFACE;
288: if id=0 then id:=1;
289: else select max(id)+1 into id from JTF_TTY_GEO_WEBADI_INTERFACE;