DBA Data[Home] [Help]

APPS.JTF_TTY_GEO_TERRGP dependencies on DUAL

Line 128: from dual;

124:
125: else
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;

Line 132: from dual;

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;
135:
136: BEGIN

Line 370: from dual;

366: END IF;
367:
368: select jtf_tty_geo_grp_values_s.nextval
369: into L_GEO_GRP_VALUES_ID
370: from dual;
371:
372: insert into jtf_tty_geo_grp_values (
373: GEO_GRP_VALUES_ID
374: , OBJECT_VERSION_NUMBER

Line 426: from dual;

422: loop
423: --
424: select jtf_tty_terr_grp_roles_s.nextval
425: into lp_terr_grp_role_id
426: from dual;
427: --
428: BEGIN
429:
430: insert into jtf_tty_terr_grp_roles (