APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 615: DELETE from JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN

611: --Delete Territory usgs
612: DELETE from JTF_TERR_USGS_ALL WHERE TERR_ID = c.Terr_Id;
613:
614: --Delete Territory Resource Access
615: DELETE from JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN
616: ( SELECT TERR_RSC_ID FROM JTF_TERR_RSC_ALL WHERE TERR_ID = c.Terr_Id );
617:
618: -- Delete the Territory Resource records
619: DELETE from JTF_TERR_RSC_ALL Where TERR_ID = c.Terr_Id;