APPS.JTF_TTY_GEO_TERRGP dependencies on JTF_TTY_GEO_TERR_S
Line 130: select jtf_tty_geo_terr_s.nextval
126: select jtf_tty_terr_groups_s.nextval
127: into l_terr_grp_id
128: from dual;
129: 130: select jtf_tty_geo_terr_s.nextval 131: into l_geo_terr_id
132: from dual;
133:
134: end if;
Line 690: SELECT jtf_tty_geo_terr_s.nextval, terr_group_name
686: p_geo_territory_id NUMBER;
687: p_geo_territory_name VARCHAR2(80);
688: p_territory_label VARCHAR2(80);
689: BEGIN 690: SELECT jtf_tty_geo_terr_s.nextval, terr_group_name 691: INTO p_geo_territory_id, p_geo_territory_name
692: FROM jtf_tty_terr_groups
693: WHERE terr_group_id = p_terr_gp_id;
694: /*