SELECT
  ICDCode.ICDCodeID,
  ICDCode.ICDCode,
  ICDCode.ICDText,
  ICDCode.startDate,
  ICDCode.endDate,
  versionNumber
INTO
  :ICDCodeID,
  :ICDCode,
  :ICDText,
  :startDate,
  :endDate,
  :ICDVersion 
FROM
  ICDCode,
  ICDCodeVersion 
WHERE 
  (
    
    (
      :searchKeyICDCodeInd = '0' 
      OR upper(ICDCode.ICDCode) like :ICDCode 
    ) 
    AND 
    (
      :searchKeyICDTextInd = '0' 
      OR upper(ICDCode.ICDText) like :ICDText 
    ) 
    AND 
    (
      :searchKeyICDVersionInd = '0' 
      OR ICDCodeVersion.ICDCodeVersionID = :ICDVersionID 
    ) 
    AND 
    (
      ICDCode.ICDCodeVersionID = ICDCodeVersion.ICDCodeVersionID 
    ) 
    AND 
    (
      ICDCode.recordStatus = :recordStatus 
    ) 
    AND 
    (
      ICDCode.endDate IS NULL 
      OR ICDCode.endDate >= current_date 
    ) 
  ) 
ORDER BY ICDCode.ICDCode