DECLARE @REQ_ID VARCHAR(15) SET @REQ_ID =(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID ='082021/000811') PRINT @REQ_ID SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =@REQ_ID SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='082021/000811' SELECT * FROM TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID =@REQ_ID SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID ----2021914