SELECT
  COUNT (*)
INTO
  :count 
FROM
  Condition 
WHERE upper(name) = :name 
  AND recordStatus = :recordStatus