DBA Data[Home] [Help]

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: /*