APPS.JTF_TTY_GEO_WEBADI_INT_PKG dependencies on DUAL

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;

Line 692: select jtf_tty_geo_terr_values_s.nextval into n from dual;

688: --insert into tmp values('enter',p_geo_terr_name); commit;
689: -- n: geo_terr_value_id
690: if trim(p_geo_terr_value_id) is null then
691: -- new geo_terr_value_id
692: select jtf_tty_geo_terr_values_s.nextval into n from dual;
693: else n:=trim(p_geo_terr_value_id);
694: end if;
695:
696:

Line 804: FROM DUAL;

800: --dbms_output.put_line(' terr_qual_id ID ******* is NULL');
801: /* insert in terr_qual_all table using sequence*/
802: SELECT JTF_TERR_QUAL_S.NEXTVAL
803: INTO l_terr_qual_id
804: FROM DUAL;
805: --dbms_output.put_line(' AFter select ing from seq qual id');
806:
807: INSERT INTO jtf_terr_qual_all
808: ( TERR_QUAL_ID

Line 944: from sys.dual;

940: to do an incremental and Total Mode */
941:
942: select jtf_tty_named_acct_changes_s.nextval
943: into l_change_id
944: from sys.dual;
945:
946: insert into jtf_tty_named_acct_changes
947: ( NAMED_ACCT_CHANGE_ID
948: , OBJECT_VERSION_NUMBER