APPS.JTY_COLLECTION_MIGRATION_PKG dependencies on JTF_TERR_QUAL_ALL

Line 154: from JTF_TERR_QUAL_ALL jtq,

150: jtq.CREATION_DATE, jtq.CREATED_BY, jtq.LAST_UPDATE_LOGIN,
151: col_usg.qual_usg_id QUAL_USG_ID, jtq.QUALIFIER_MODE,
152: jtq.OVERLAP_ALLOWED_FLAG, jtq.USE_TO_NAME_FLAG, jtq.GENERATE_FLAG,
153: jtq.ORG_ID, jtq.SECURITY_GROUP_ID, jtq.OBJECT_VERSION_NUMBER
154: from JTF_TERR_QUAL_ALL jtq,
155: jtf_qual_usgs_all col_usg, jtf_qual_usgs_all sales_usg
156: where jtq.terr_id = v_terr_id
157: and jtq.qual_usg_id = sales_usg.qual_usg_id
158: and jtq.org_id = sales_usg.org_id

Line 367: INSERT INTO JTF_TERR_QUAL_ALL (

363: CLOSE get_terr_qual_csr;
364:
365: IF (l_terr_qual_rec.NEW_TERR_QUAL_ID.COUNT > 0) THEN
366: forall j in l_terr_qual_rec.NEW_TERR_QUAL_ID.first..l_terr_qual_rec.NEW_TERR_QUAL_ID.last
367: INSERT INTO JTF_TERR_QUAL_ALL (
368: TERR_QUAL_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
369: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
370: TERR_ID,
371: QUAL_USG_ID, QUALIFIER_MODE,

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