Project

General

Profile

Download (297 Bytes)

2.1 DUYET TGD NBO.2021.000210.txt

Luc Tran Van, 07/05/2021 01:16 PM

 
1 

    		
  

  

    
      2
    
    
      
DECLARE @REQ_ID VARCHAR(15)


    		
  

  

    
      3
    
    
      
SET @REQ_ID=(SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE ='NBO.2021.000210')


    		
  

  

    
      4
    
    
      
EXEC TR_REQ_ADVANCE_PAYMENT_Appr @REQ_ID,'trungnq1','A',NULL


    		
  

  

    
      5
    
    
      
DELETE FROM PL_PROCESS WHERE CHECKER_ID ='trungnq1' AND REQ_ID =@REQ_ID


    		
  

  

    
      6
    
    
      

    		
  

  

    
      7
    
    
      
SELECT * FROM TL_SYSROLE_LIMIT