1.1 CHECK PDN THANH TOAN 000811.txt
| 1 |
DECLARE @REQ_ID VARCHAR(15) |
|---|---|
| 2 |
SET @REQ_ID =(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID ='082021/000811') |
| 3 |
PRINT @REQ_ID |
| 4 |
SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =@REQ_ID |
| 5 |
SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='082021/000811' |
| 6 |
SELECT * FROM TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID =@REQ_ID |
| 7 |
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID |
| 8 |
----2021914 |