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

DELETE TR_REQUEST_CAR WHERE REQ_ID=@ID
DELETE TR_REQUEST_CAR_DETAIL WHERE REQ_ID=@ID
DELETE TR_REQ_CAR_FUEL WHERE REQ_ID=@ID
DELETE TR_REQUEST_JOB_FORM WHERE REQ_ID=@ID_PYCCT
DELETE TR_REQUEST_JOB_DETAIL WHERE REQ_ID=@ID_PYCCT
DELETE TR_REQUEST_JOB_TRAIN WHERE REQ_ID=@ID_PYCCT