Project

General

Profile

Download (341 Bytes)

FILE 1.4.txt

Truong Nguyen Vu, 09/11/2020 09:54 AM

 
1 
DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID=1506
2 

    		
  

  

    
      3
    
    
      
UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='C' WHERE ID=1507


    		
  

  

    
      4
    
    
      
UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='APPROVE' WHERE REQ_ID='PLRD00000200132'


    		
  

  

    
      5
    
    
      

    		
  

  

    
      6
    
    
      
EXEC dbo.PL_REQ_DOC_UPDATE_AFTER_APPROVE @p_REQ_ID = 'PLRD00000200132';


    		
  

  

    
      7
    
    
      
EXEC dbo.PL_REQ_DOC_Ins_To_TR_REQ_DOC @p_PL_REQ_ID = 'PLRD00000200132';