Project

General

Profile

Download (388 Bytes)

update PUR_2023_000248.txt

Luc Tran Van, 03/27/2023 03:14 PM

 
1 
DECLARE @req_id varchar(20),@date DATETIME
2 
SELECT @req_id = trd.REQ_ID FROM TR_REQUEST_DOC trd where trd.REQ_CODE = 'PUR/2023/000248'
3 

    		
  

  

    
      4
    
    
      
SELECT @date = pac.REQ_DT FROM PL_APPOINT_CONTRACTOR pac WHERE pac.REQ_ID = @req_id


    		
  

  

    
      5
    
    
      

    		
  

  

    
      6
    
    
      
UPDATE PL_REQUEST_PROCESS SET APPROVE_DT = @date WHERE ID IN ('91539','94782')


    		
  

  

    
      7
    
    
      

    		
  

  

    
      8
    
    
      
UPDATE PL_PROCESS SET APPROVE_DT = @date WHERE id IN ('496831','494175','493588')