1.0 GET THONG TIN PHIEU THANH TOAN.txt
| 1 |
DECLARE @REQ_ID VARCHAR(15) |
|---|---|
| 2 |
SET @REQ_ID=(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='042022/000397') |
| 3 |
SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID=@REQ_ID |
| 4 |
SELECT * FROM TR_REQ_ADVANCE_DT WHERE REQ_PAY_ID=@REQ_ID |
| 5 |
SELECT * FROM TR_REQ_PAY_SCHEDULE WHERE REQ_PAY_ID=@REQ_ID |
| 6 |
SELECT * FROM TR_REQ_PAY_METHOD WHERE REQ_PAY_ID=@REQ_ID |
| 7 |
SELECT * FROM TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID=@REQ_ID |
| 8 |
---202248 |