Project

General

Profile

Download (389 Bytes)

2.0 CHECK NS CP 092021 000375.txt

Luc Tran Van, 09/14/2021 08:29 PM

 
1 
DECLARE @p_REQ_ID VARCHAR(15)
2 
SET @p_REQ_ID =(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID ='092021/000375')
3 
PRINT @p_REQ_ID
4 
SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =@p_REQ_ID
5 
SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='092021/000375'
6 
SELECT * FROM TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID =(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='092021/000375')