APPS.JTY_COLLECTION_MIGRATION_PKG dependencies on JTF_TERR_VALUES_ALL

Line 387: INSERT INTO JTF_TERR_VALUES_ALL (

383:
384: --dbms_output.put_line('Terr qual all insert completed: ' ||SQL%ROWCOUNT);
385:
386: forall i in l_terr_qual_rec.TERR_QUAL_ID.first..l_terr_qual_rec.TERR_QUAL_ID.last
387: INSERT INTO JTF_TERR_VALUES_ALL (
388: TERR_VALUE_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE,
389: CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
390: TERR_QUAL_ID, INCLUDE_FLAG, COMPARISON_OPERATOR,
391: ID_USED_FLAG, LOW_VALUE_CHAR_ID, LOW_VALUE_CHAR,

Line 409: FROM JTF_TERR_VALUES_ALL jtv, JTF_TERR_QUAL_ALL jtq

405: jtv.SECONDARY_INTEREST_CODE_ID, jtv.CURRENCY_CODE, jtv.ORG_ID,
406: jtv.SECURITY_GROUP_ID, jtv.CNR_GROUP_ID, jtv.VALUE1_ID,
407: jtv.VALUE2_ID, jtv.VALUE3_ID, jtv.FIRST_CHAR,
408: jtv.OBJECT_VERSION_NUMBER, jtv.VALUE4_ID, jtv.SELF_SERVICE_TERR_VALUE_ID
409: FROM JTF_TERR_VALUES_ALL jtv, JTF_TERR_QUAL_ALL jtq
410: WHERE jtv.TERR_QUAL_ID = jtq.terr_qual_id
411: and jtv.org_id = jtq.org_id
412: and jtq.terr_id = l_terr_qual_rec.TERR_ID(i)
413: and jtq.terr_qual_id = l_terr_qual_rec.terr_qual_id(i));