DECLARE @p_REQ_ID VARCHAR(15) SET @p_REQ_ID =(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID ='092021/000375') PRINT @p_REQ_ID SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =@p_REQ_ID SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='092021/000375' SELECT * FROM TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID =(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='092021/000375')