DECLARE @REQ_ID VARCHAR(15), @REASON NVARCHAR(1000)
SET @REQ_ID= (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='072021/000955')
SELECT *  FROM TR_REQ_PAY_BUDGET WHERE  REQ_PAY_ID =(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='072021/000955')
SET @REASON =(SELECT top 1 REASON  FROM TR_REQ_PAY_BUDGET WHERE  REQ_PAY_ID =@REQ_ID)
UPDATE TR_REQ_PAY_BUDGET SET AMT_APP = 165252750.0, AMT_DO=0, AMT_REMAIN = 165252750, AMT_EXE =89611000 WHERE  REQ_PAY_ID =@REQ_ID AND TRADE_ID ='PLT000000271310'
INSERT INTO TR_REQ_PAY_BUDGET(BUDG_ID, GD_ID, REQ_PAY_ID, TRADE_ID, AMT_APP, AMT_DO, AMT_EXE, AMT_REMAIN, MAKER_ID, CREATE_DT, CURRENCY, RATE, REASON, NOTES, TYPE_COST, FR_LEVEL, TO_LEVEL)
VALUES
('BUDGID000000001','GOO000000253126',@REQ_ID,'PLT000000271238',193391250,0,96695925,193391250,'phuongvn',GETDATE(),'VND',1,@REASON,'',NULL,0,0)
SELECT *  FROM TR_REQ_PAY_BUDGET WHERE  REQ_PAY_ID =@REQ_ID
SET @REQ_ID= (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='082021/000300')
SELECT *  FROM TR_REQ_PAY_BUDGET WHERE  REQ_PAY_ID =@REQ_ID