APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_RSC_ALL

Line 616: ( SELECT TERR_RSC_ID FROM JTF_TERR_RSC_ALL WHERE TERR_ID = c.Terr_Id );

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;
620:

Line 619: DELETE from JTF_TERR_RSC_ALL Where TERR_ID = c.Terr_Id;

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;
620:
621: --Delete Territory record
622: DELETE from JTF_TERR_ALL WHERE TERR_ID = c.Terr_Id;
623: