Project

General

Profile

1.0 CHEN CAP HDQT VAO TO TRINH CHU TRUONG 0158 2021 0690604.txt

Luc Tran Van, 07/13/2021 01:44 PM

 
1
DECLARE @REQ_ID VARCHAR(15)
2
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0158/2021/TTr-0690604')
3
INSERT INTO PL_REQUEST_PROCESS VALUES (@REQ_ID,'HDQT','P','HDQT','DV0001','',NULL,'TGD','N','','',N'Chủ tịch HĐQT đã phê duyệt','0','')
4
UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='HDQT' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='APPROVE'
5
--- CHEN CAP HDQT VAO TO TRINH SO 0158 2021 0690604