APPS.JTY_COLLECTION_MIGRATION_PKG dependencies on JTF_TERR_RSC_ALL

Line 421: INSERT INTO JTF_TERR_RSC_ALL (

417: END LOOP; -- copy terr qual rows
418:
419: -- copy terr resource rows
420: forall i in l_terr_def_rec.NEW_TERR_ID.first..l_terr_def_rec.NEW_TERR_ID.last
421: INSERT INTO JTF_TERR_RSC_ALL (
422: TERR_RSC_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
423: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
424: TERR_ID, RESOURCE_ID, RESOURCE_TYPE,
425: ROLE, PRIMARY_CONTACT_FLAG, START_DATE_ACTIVE,

Line 446: FROM JTF_TERR_RSC_ALL

442: ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,
443: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10,
444: ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13,
445: ATTRIBUTE14, ATTRIBUTE15
446: FROM JTF_TERR_RSC_ALL
447: where terr_id = l_terr_def_rec.TERR_ID(i));
448: --dbms_output.put_line('Terr rsc all insert completed: ' ||SQL%ROWCOUNT);
449:
450: END IF;

Line 464: FROM JTF_TERR_RSC_ALL

460:
461: SELECT TERR_RSC_ID, TERR_ID, l_terr_def_rec.TERR_ID(i)
462: BULK COLLECT INTO l_terr_rsc_rec.terr_rsc_id,
463: l_terr_rsc_rec.new_terr_id, l_terr_rsc_rec.terr_id
464: FROM JTF_TERR_RSC_ALL
465: WHERE TERR_ID = l_terr_def_rec.NEW_TERR_ID(i);
466:
467: --dbms_output.put_line('Terr_rsc_id Row count: ' ||l_terr_rsc_rec.terr_rsc_id.count);
468:

Line 483: FROM JTF_TERR_RSC_ALL jtr, JTF_TERR_RSC_ACCESS_ALL jtra

479: jtra.CREATION_DATE, jtra.CREATED_BY, jtra.LAST_UPDATE_LOGIN,
480: l_terr_rsc_rec.terr_rsc_id(i) TERR_RSC_ID,
481: l_access_type ACCESS_TYPE, jtra.ORG_ID,
482: jtra.SECURITY_GROUP_ID, jtra.OBJECT_VERSION_NUMBER, jtra.TRANS_ACCESS_CODE
483: FROM JTF_TERR_RSC_ALL jtr, JTF_TERR_RSC_ACCESS_ALL jtra
484: where jtr.terr_rsc_id = jtra.terr_rsc_id
485: and jtr.terr_id = l_terr_rsc_rec.terr_id(i)
486: and rownum = 1;
487: --dbms_output.put_line('Terr rsc access all insert completed: ' ||SQL%ROWCOUNT);