APPS.JTF_TTY_GEO_WEBADI_INT_PKG dependencies on DUAL

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

273: delete from JTF_TTY_GEO_WEBADI_INTERFACE
274: where user_id = p_userid
275: and sysdate - creation_date >2;
276:
277: select jtf_tty_geo_int_s.nextval into SEQ from dual;
278:
279: select count(*) into id from JTF_TTY_GEO_WEBADI_INTERFACE;
280: if id=0 then id:=1;
281: else select max(id)+1 into id from JTF_TTY_GEO_WEBADI_INTERFACE;

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

668: --insert into tmp values('enter',p_geo_terr_name); commit;
669: -- n: geo_terr_value_id
670: if trim(p_geo_terr_value_id) is null then
671: -- new geo_terr_value_id
672: select jtf_tty_geo_terr_values_s.nextval into n from dual;
673: else n:=trim(p_geo_terr_value_id);
674: end if;
675:
676:

Line 784: FROM DUAL;

780: --dbms_output.put_line(' terr_qual_id ID ******* is NULL');
781: /* insert in terr_qual_all table using sequence*/
782: SELECT JTF_TERR_QUAL_S.NEXTVAL
783: INTO l_terr_qual_id
784: FROM DUAL;
785: --dbms_output.put_line(' AFter select ing from seq qual id');
786:
787: INSERT INTO jtf_terr_qual_all
788: ( TERR_QUAL_ID

Line 924: from sys.dual;

920: to do an incremental and Total Mode */
921:
922: select jtf_tty_named_acct_changes_s.nextval
923: into l_change_id
924: from sys.dual;
925:
926: insert into jtf_tty_named_acct_changes
927: ( NAMED_ACCT_CHANGE_ID
928: , OBJECT_VERSION_NUMBER