Project

General

Profile

Download (502 Bytes)

PYC-XE2023000857.txt

Luc Tran Van, 04/25/2023 05:39 PM

 
1 
DECLARE @ID VARCHAR(20), @ID_PYCCT VARCHAR(20)
2 
SET @ID=(SELECT REQ_ID FROM TR_REQUEST_CAR WHERE REQ_CODE='PYC-XE/2023/000857')
3 
SET @ID_PYCCT=(SELECT REQ_ID FROM TR_REQUEST_JOB_FORM trjf WHERE trjf.REQ_ID=@ID_PYCCT)
4 

    		
  

  

    
      5
    
    
      
DELETE TR_REQUEST_CAR WHERE REQ_ID=@ID


    		
  

  

    
      6
    
    
      
DELETE TR_REQUEST_CAR_DETAIL WHERE REQ_ID=@ID


    		
  

  

    
      7
    
    
      
DELETE TR_REQ_CAR_FUEL WHERE REQ_ID=@ID


    		
  

  

    
      8
    
    
      
DELETE TR_REQUEST_JOB_FORM WHERE REQ_ID=@ID_PYCCT


    		
  

  

    
      9
    
    
      
DELETE TR_REQUEST_JOB_DETAIL WHERE REQ_ID=@ID_PYCCT


    		
  

  

    
      10
    
    
      
DELETE TR_REQUEST_JOB_TRAIN WHERE REQ_ID=@ID_PYCCT