[Home] [Help]
APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_TERR_RSC_ACCESS_ALL
Line 289: DELETE from JTF_TERR_RSC_ACCESS_ALL jtra
285: WHERE jt.terr_group_flag = 'Y' );
286:
287:
288: --Delete Territory Resource Access
289: DELETE from JTF_TERR_RSC_ACCESS_ALL jtra
290: WHERE jtra.terr_rsc_id IN
291: ( SELECT jtr.terr_rsc_id
292: FROM jtf_terr_rsc_all jtr, jtf_terr_all jt
293: WHERE jtr.terr_id = jt.terr_id