APPS.JTY_COLLECTION_MIGRATION_PKG dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 472: INSERT INTO JTF_TERR_RSC_ACCESS_ALL

468:
469: -- copy resource access rows
470: IF (l_terr_rsc_rec.terr_rsc_id.COUNT > 0) THEN
471: forall i in l_terr_rsc_rec.terr_rsc_id.first..l_terr_rsc_rec.terr_rsc_id.last
472: INSERT INTO JTF_TERR_RSC_ACCESS_ALL
473: (TERR_RSC_ACCESS_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
474: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
475: TERR_RSC_ID, ACCESS_TYPE, ORG_ID,
476: SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER, TRANS_ACCESS_CODE )

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);