DECLARE  @DATE DATETIME, @REQ_ID VARCHAR(15)
SET @DATE ='2021-04-16 12:00:00 AM'
SET @REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/000457')
UPDATE TR_REQUEST_DOC_DT SET OFFERING_VALUE =85168.6 WHERE PRICE =85168.6 AND  REQ_DOC_ID =@REQ_ID
UPDATE TR_REQUEST_DOC_DT SET OFFERING_VALUE = 98213.5 WHERE PRICE =98213.5 AND  REQ_DOC_ID =@REQ_ID