SELECT
  conditionID,
  name,
  type,
  recordStatus
INTO
  :conditionID,
  :conditionName,
  :conditionType,
  :status 
FROM
  Condition 
WHERE 
  (
    
    (
      :searchKeyConditionNameInd = '0' 
      OR upper(name) like :conditionName 
    ) 
    AND 
    (
      :searchKeyConditionTypeInd = '0' 
      OR type = :conditionType 
    ) 
    AND 
    (
      endDate IS NULL 
      OR endDate >= current_date 
    ) 
    AND 
    (
      recordStatus = :recordStatus 
    ) 
  ) 
ORDER BY name