Support #804
Cập nhật ngày lùi cho PUR + TTCT (PUR/2020/000828, 0145/2020/TTr-0690604)
Start date:
01/06/2021
Due date:
% Done:
0%
Estimated time:
Description
DECLARE @REQ_ID VARCHAR
SET @REQ_ID= (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000828')
UPDATE PL_PROCESS SET APPROVE_DT ='2020-12-18' WHERE REQ_ID =@REQ_ID
UPDATE TR_REQUEST_DOC SET APPROVE_DT ='2020-12-18' WHERE REQ_ID =@REQ_ID
----
SET @REQ_ID= (SELECT TOP 1 REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0145/2020/TTr-0690604')
UPDATE PL_REQUEST_DOC SET REQ_DT ='2020-12-08', EFFEC_DT ='2020-12-08' WHERE REQ_ID =@REQ_ID
UPDATE PL_REQUEST_PROCESS SET APPROVE_DT ='2020-12-08' WHERE REQ_ID =@REQ_ID
History
#1 Updated by Luc Tran Van over 4 years ago
- Status changed from New to Closed