DECLARE @REQ_ID NVARCHAR(20) = NULL
SELECT @REQ_ID = REQUEST_TEMPLATE_ID
FROM dbo.CM_REQUEST_TEMPLATE
WHERE REPORT_NO = '0003/2023/TTr-0350007'

SELECT * FROM CM_REQUEST_TEMPLATE WHERE REQUEST_TEMPLATE_ID = @REQ_ID
SELECT * FROM dbo.CM_APPROVE_GROUP WHERE REQ_ID = @REQ_ID
SELECT * FROM dbo.CM_TEMPLATE_LOG WHERE REQ_ID = @REQ_ID