UPDATE CM_REQUEST_TEMPLATE 
SET AUTH_STATUS = 'O'
WHERE REQUEST_TEMPLATE_ID = 'CRTEM0000000168'

declare @REPORT_NO NVARCHAR(50)=N'000132/2023TTR-0690604'
declare @REQUEST_TEMPLATE_ID NVARCHAR(20)=(SELECT REQUEST_TEMPLATE_ID FROM CM_REQUEST_TEMPLATE WHERE REPORT_NO=@REPORT_NO)
DELETE dbo.CM_TEMPLATE_NOTE WHERE REQ_ID = @REQUEST_TEMPLATE_ID