APPS.JTF_TTY_NA_GEO_TERR_PVT dependencies on JTF_TERR_VALUES_ALL

Line 240: DELETE FROM jtf_terr_values_all jtv

236: /* TOTAL mode => re-generate all NA territories */
237: IF (p_mode = 'TOTAL') THEN
238:
239: --DELETE territory value records
240: DELETE FROM jtf_terr_values_all jtv
241: WHERE jtv.terr_qual_id IN
242: ( SELECT jtq.terr_qual_id
243: FROM jtf_terr_qual_all jtq, jtf_terr_all jt
244: WHERE jtq.terr_id = jt.terr_id

Line 771: FROM jtf_terr_values_all jtv

767: , jtv.CURRENCY_CODE
768: , jtv.ORG_ID
769: , jtv.ID_USED_FLAG
770: , jtv.LOW_VALUE_CHAR_ID
771: FROM jtf_terr_values_all jtv
772: WHERE jtv.terr_qual_id = lp_terr_qual_id;
773:
774:
775: /* get those roles for a territory Group that

Line 4011: FROM jtf_terr_values_all jtv

4007: , jtv.CURRENCY_CODE
4008: , jtv.ORG_ID
4009: , jtv.ID_USED_FLAG
4010: , jtv.LOW_VALUE_CHAR_ID
4011: FROM jtf_terr_values_all jtv
4012: WHERE jtv.terr_qual_id = lp_terr_qual_id;
4013:
4014: /* get the geographies
4015: ** used for OVERLAY territory creation */