DBA Data[Home] [Help]

APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_RSC_ALL

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

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

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

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;
612:
613: --Delete Territory record
614: DELETE from JTF_TERR_ALL WHERE TERR_ID = c.Terr_Id;
615: