APPS.JTY_COLLECTION_MIGRATION_PKG dependencies on JTF_TERR_ALL

Line 134: from JTF_TERR_ALL terr

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
138: AND terr.TERR_ID <> 1

Line 267: INSERT INTO JTF_TERR_ALL (

263: --dbms_output.put_line('New terr_id: '|| l_terr_def_rec.NEW_TERR_ID(i));
264: end loop;
265:
266: forall i in l_terr_def_rec.TERR_ID.first..l_terr_def_rec.TERR_ID.last
267: INSERT INTO JTF_TERR_ALL (
268: TERR_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
269: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
270: APPLICATION_SHORT_NAME, NAME, RANK,
271: ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE,

Line 298: UPDATE JTF_TERR_ALL

294:
295: --dbms_output.put_line('Terr def insert completed: ' ||SQL%ROWCOUNT);
296:
297: forall i in l_terr_def_rec.NEW_TERR_ID.first..l_terr_def_rec.NEW_TERR_ID.last
298: UPDATE JTF_TERR_ALL
299: set parent_territory_id = l_terr_def_rec.NEW_TERR_ID(i)
300: where parent_territory_id = l_terr_def_rec.TERR_ID(i)
301: and TERRITORY_TYPE_ID = l_terr_type_id;
302: