Project

General

Profile

Download (541 Bytes)

1.9 THEM LOG TGD TTCT 0042 2021 0690405.txt

Luc Tran Van, 08/16/2021 08:26 PM

 
1 

    		
  

  

    
      2
    
    
      
DECLARE @REQ_ID VARCHAR(15)


    		
  

  

    
      3
    
    
      
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0042/2021/TTr-0690405')


    		
  

  

    
      4
    
    
      
INSERT INTO PL_REQUEST_PROCESS VALUES (@REQ_ID,'TGD','P','TGD','DV0001','trungnq1','5/18/2021 10:30:53 AM','PTGDK_TT','N','','',N'Tổng giám đốc đã phê duyệt','0','')


    		
  

  

    
      5
    
    
      
INSERT INTO PL_PROCESS VALUES (@REQ_ID,'TGD','trungnq1','5/18/2021 10:30:53 AM',N'Phê duyệt',N'Tổng giám đốc đã phê duyệt')


    		
  

  

    
      6
    
    
      
UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='TGD' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='APPROVE'