APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 607: DELETE from JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN

603: --Delete Territory usgs
604: DELETE from JTF_TERR_USGS_ALL WHERE TERR_ID = c.Terr_Id;
605:
606: --Delete Territory Resource Access
607: DELETE from JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN
608: ( SELECT TERR_RSC_ID FROM JTF_TERR_RSC_ALL WHERE TERR_ID = c.Terr_Id );
609:
610: -- Delete the Territory Resource records
611: DELETE from JTF_TERR_RSC_ALL Where TERR_ID = c.Terr_Id;