test

SELECT
  CK.RIYO_CD,
  CK.CONSENT_ID,
  CK.CONSENT_VERSION,
  CK.START_DATE,
  CK.END_DATE
FROM
  (
    SELECT
      RIYO_CD,
      CONSENT_ID,
      MAX(CONSENT_VERSION) AS CONSENT_VERSION
    FROM
      CONSENT_STATE_KNR
    WHERE
      RIYO_CD = :riyoCd
    GROUP BY
      RIYO_CD, CONSENT_ID
  ) CSK
JOIN CONSENT_KNR CK
  ON CK.RIYO_CD = CSK.RIYO_CD
 AND CK.CONSENT_ID = CSK.CONSENT_ID
 AND CK.CONSENT_VERSION = CSK.CONSENT_VERSION
WHERE
  TO_DATE(CK.START_DATE, 'YYYYMMDD') <= TRUNC(SYSDATE)
  AND TO_DATE(CK.END_DATE, 'YYYYMMDD') >= TRUNC(SYSDATE)
  AND CK.RIYO_CD = :riyoCd;