DECLARE @REQ_ID VARCHAR(15) SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0008/2021/TTr-0692103') UPDATE PL_REQUEST_DOC SET IS_SETTLMENT =0 WHERE REQ_ID =@REQ_ID EXEC PL_REQUEST_DOC_Settlment @REQ_ID,0,0,0