DECLARE @req_id varchar(20),@date DATETIME
SELECT @req_id = trd.REQ_ID FROM TR_REQUEST_DOC trd where trd.REQ_CODE = 'PUR/2023/000248'

SELECT @date = pac.REQ_DT FROM PL_APPOINT_CONTRACTOR pac WHERE pac.REQ_ID = @req_id

UPDATE PL_REQUEST_PROCESS SET APPROVE_DT = @date WHERE ID IN ('91539','94782')

UPDATE PL_PROCESS SET APPROVE_DT = @date WHERE id IN ('496831','494175','493588')