|
1
|
DECLARE @REQ_ID VARCHAR(15), @REASON NVARCHAR(1000)
|
|
2
|
SET @REQ_ID= (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='072021/000955')
|
|
3
|
SELECT * FROM TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID =(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='072021/000955')
|
|
4
|
SET @REASON =(SELECT top 1 REASON FROM TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID =@REQ_ID)
|
|
5
|
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'
|
|
6
|
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)
|
|
7
|
VALUES
|
|
8
|
('BUDGID000000001','GOO000000253126',@REQ_ID,'PLT000000271238',193391250,0,96695925,193391250,'phuongvn',GETDATE(),'VND',1,@REASON,'',NULL,0,0)
|
|
9
|
SELECT * FROM TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID =@REQ_ID
|
|
10
|
SET @REQ_ID= (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='082021/000300')
|
|
11
|
SELECT * FROM TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID =@REQ_ID
|