APPS.JTF_TTY_NA_GEO_TERR_PVT dependencies on JTF_TERR_QUAL_ALL

Line 243: FROM jtf_terr_qual_all jtq, jtf_terr_all jt

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
245: AND jt.terr_group_flag = 'Y' );
246:
247: COMMIT;

Line 250: DELETE from JTF_TERR_QUAL_ALL jtq

246:
247: COMMIT;
248:
249: --Delete Territory Qualifer records
250: DELETE from JTF_TERR_QUAL_ALL jtq
251: WHERE jtq.terr_id IN
252: ( SELECT jt.terr_id
253: FROM jtf_terr_all jt
254: WHERE jt.terr_group_flag = 'Y' );

Line 751: FROM jtf_terr_qual_all jtq

747: /* get Qualifiers used in a territory */
748: CURSOR csr_get_qual( lp_terr_id NUMBER) IS
749: SELECT jtq.terr_qual_id
750: , jtq.qual_usg_id
751: FROM jtf_terr_qual_all jtq
752: WHERE jtq.terr_id = lp_terr_id;
753:
754: /* get Values used in a territory qualifier */
755: CURSOR csr_get_qual_val ( lp_terr_qual_id NUMBER ) IS

Line 3991: FROM jtf_terr_qual_all jtq

3987: /* get Qualifiers used in a territory */
3988: CURSOR csr_get_qual( lp_terr_id NUMBER) IS
3989: SELECT jtq.terr_qual_id
3990: , jtq.qual_usg_id
3991: FROM jtf_terr_qual_all jtq
3992: WHERE jtq.terr_id = lp_terr_id;
3993:
3994: /* get Values used in a territory qualifier */
3995: CURSOR csr_get_qual_val ( lp_terr_qual_id NUMBER ) IS