Update Multiple Table with Single Parramete in single procdure

Create  PROCEDURE DeleteRecycleAssignmentGiven      
       
@Given_Id  int             
                
AS             
 SET NOCOUNT ON             
 SET XACT_ABORT ON              
             
 BEGIN TRAN          
         
         
 UPDATE    dbo.S_Assignment_Given_Master
 SET    S_Assignment_Given_Master.IsDelete='true'  
	WHERE  Given_Id = @Given_Id   

 UPDATE    dbo.S_Assignment_Given_Child
 SET    S_Assignment_Given_Master.IsDelete='true'  
	WHERE  Given_Id = @Given_Id   

 UPDATE    dbo.Batch_Assignment_Mst
 SET    S_Assignment_Given_Master.IsDelete='true'  
	WHERE  Given_Id = @Given_Id   

COMMIT