Project

General

Profile

Download (325 Bytes)

4.0 ENABLE NS -CP PHONG BAN 8990000.txt

Luc Tran Van, 05/11/2021 08:33 AM

 
1 
DECLARE @DEP_ID VARCHAR(15)
2 
SET @DEP_ID =(SELECT DEP_ID FROM CM_DEPARTMENT WHERE DEP_CODE ='8990000')
3 

    		
  

  

    
      4
    
    
      
UPDATE PL_MASTER SET RECORD_STATUS ='1', AUTH_STATUS ='A' WHERE DEPT_ID =@DEP_ID


    		
  

  

    
      5
    
    
      
UPDATE PL_TRADEDETAIL SET RECORD_STATUS ='1', AUTH_STATUS ='A' WHERE PLAN_ID


    		
  

  

    
      6
    
    
      
IN ( SELECT PLAN_ID FROM PL_MASTER WHERE DEPT_ID =@DEP_ID)