Feature #1556
VẬN HÀNH DỰ ÁN SAU GOLIVE NGÀY 25.09.2023
Start date:
09/25/2023
Due date:
% Done:
0%
Estimated time:
History
#1 Updated by Luc Tran Van over 1 year ago
DECLARE @NGAYLUI_2 VARCHAR = '16/08/2023 00:00:00'
UPDATE PL_APPOINT_CONTRACTOR SET REQ_DT = CONVERT, CREATE_DT = CONVERT WHERE REQ_CODE = '000076/2023/TTr-P.HC-BP.MH'
DECLARE @REQ_ID_PYCMS_2 VARCHAR = (SELECT TOP 1 pac.TR_REQUEST_DOC_ID FROM PL_APPOINT_CONTRACTOR pac WHERE PAC.REQ_CODE = '000076/2023/TTr-P.HC-BP.MH')
UPDATE PL_REQUEST_PROCESS SET APPROVE_DT = CONVERT WHERE REQ_ID = @REQ_ID_PYCMS_2
UPDATE PL_PROCESS SET APPROVE_DT = CONVERT WHERE REQ_ID = @REQ_ID_PYCMS_2