Project

General

Profile

Download (385 Bytes)

1.0 CHECK NS -CHI PHI PDN TAM UNG NCC.2021.000567.txt

Luc Tran Van, 07/15/2021 03:57 PM

 
1 
SELECT * FROM TR_CONTRACT WHERE CONTRACT_ID ='TRC000000252346'
2 
DECLARE @REQ_ID VARCHAR(15)
3 
SET @REQ_ID =(SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE ='NCC.2021.000567')
4 
DELETE FROM TR_REQ_ADVANCE_DT WHERE REQ_PAY_ID =@REQ_ID
5 
DELETE FROM TR_REQ_PAY_SCHEDULE WHERE REQ_PAY_ID =@REQ_ID
6 
UPDATE TR_REQ_ADVANCE_PAYMENT SET AUTH_STATUS ='E' WHERE REQ_PAY_ID =@REQ_ID