APPS.JTY_COLLECTION_MIGRATION_PKG dependencies on JTF_TERR_S

Line 133: --JTF_TERR_s.nextval NEW_TERR_ID

129: terr.ATTRIBUTE9, terr.ATTRIBUTE10, terr.ATTRIBUTE11,
130: terr.ATTRIBUTE12, terr.ATTRIBUTE13, terr.ATTRIBUTE14,
131: terr.ATTRIBUTE15, terr.ORG_ID,
132: terr.NUM_WINNERS, terr.NUM_QUAL, terr.OBJECT_VERSION_NUMBER--,
133: --JTF_TERR_s.nextval NEW_TERR_ID
134: from JTF_TERR_ALL terr
135: where nvl(terr.TERR_GROUP_FLAG,'N') = 'N'
136: and NVL(terr.ENABLE_SELF_SERVICE,'N') = 'N'
137: CONNECT BY terr.parent_territory_id = PRIOR terr.terr_id

Line 261: select JTF_TERR_s.nextval into l_terr_def_rec.NEW_TERR_ID(i)

257: IF (l_terr_def_rec.TERR_ID.count > 0) THEN
258: --dbms_output.put_line('Start copy territory definition');
259:
260: for i in l_terr_def_rec.TERR_ID.first..l_terr_def_rec.TERR_ID.last loop
261: select JTF_TERR_s.nextval into l_terr_def_rec.NEW_TERR_ID(i)
262: from dual;
263: --dbms_output.put_line('New terr_id: '|| l_terr_def_rec.NEW_TERR_ID(i));
264: end loop;
265: