Project

General

Profile

Download (380 Bytes)

2.0 LUI NGAY CHU TRUONG 0154 2021 TTr 0690604.txt

Luc Tran Van, 07/09/2021 01:56 PM

 
1 

    		
  

  

    
      2
    
    
      
DECLARE @REQ_ID VARCHAR(15), @DATE DATETIME


    		
  

  

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


    		
  

  

    
      4
    
    
      
SET @DATE='2021-05-28 12:00:00 AM'


    		
  

  

    
      5
    
    
      
UPDATE PL_REQUEST_DOC SET REQ_DT =@DATE, APPROVE_DT =@DATE, EFFEC_DT =@DATE WHERE REQ_ID =@REQ_ID


    		
  

  

    
      6
    
    
      
UPDATE PL_REQUEST_PROCESS SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID


    		
  

  

    
      7
    
    
      

    		
  

  

    
      8
    
    
      
--- UPDATE NOI DUNG TAI CHINH 202179