APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_VALUES_ALL

Line 594: DELETE from JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID IN

590: -- Get all the Territories in the Hierarchy
591: FOR c in c_Terr LOOP
592: --
593: --Delete Territory Values
594: DELETE from JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID IN
595: ( SELECT TERR_QUAL_ID FROM JTF_TERR_QUAL_ALL WHERE TERR_ID = c.Terr_Id );
596:
597: --Delete Territory Qualifer records
598: DELETE from JTF_TERR_QUAL_ALL WHERE TERR_ID = c.Terr_Id;

Line 4193: From JTF_TERR_VALUES_ALL

4189: ID_USED_FLAG,
4190: LOW_VALUE_CHAR_ID,
4191: ORG_ID,
4192: CNR_GROUP_ID
4193: From JTF_TERR_VALUES_ALL
4194: Where TERR_VALUE_ID = l_TERR_VALUE_ID
4195: For Update NOWAIT;
4196:
4197: --Local variable declaration

Line 4972: DELETE jtf_terr_values_ALL

4968: NULL;
4969: END;
4970:
4971: /* Do a bulk delete of Territory Qualifier VALUES */
4972: DELETE jtf_terr_values_ALL
4973: WHERE terr_qual_id = p_terr_qual_id
4974: RETURNING terr_value_id
4975: BULK COLLECT INTO deletedIds;
4976: