APPS.JTF_TTY_NA_GEO_TERR_PVT dependencies on JTF_TERR_RSC_ALL

Line 280: FROM jtf_terr_rsc_all jtr, jtf_terr_all jt

276: --Delete Territory Resource Access
277: DELETE from JTF_TERR_RSC_ACCESS_ALL jtra
278: WHERE jtra.terr_rsc_id IN
279: ( SELECT jtr.terr_rsc_id
280: FROM jtf_terr_rsc_all jtr, jtf_terr_all jt
281: WHERE jtr.terr_id = jt.terr_id
282: AND jt.terr_group_flag = 'Y' );
283:
284: COMMIT;

Line 287: DELETE from JTF_TERR_RSC_ALL jtr

283:
284: COMMIT;
285:
286: -- Delete the Territory Resource records
287: DELETE from JTF_TERR_RSC_ALL jtr
288: WHERE jtr.terr_id IN
289: ( SELECT jt.terr_id
290: FROM jtf_terr_all jt
291: WHERE jt.terr_group_flag = 'Y' );