APPS.JTF_TTY_NA_GEO_TERR_PVT dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 277: DELETE from JTF_TERR_RSC_ACCESS_ALL jtra

273:
274: COMMIT;
275:
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