SELECT
  COUNT(*)
INTO
  :value 
FROM
  CaseHeader,
  OrgObjectLink 
WHERE OrgObjectLink.userName = :userName 
  AND OrgObjectLink.orgObjectType = :orgObjectType 
  AND CaseHeader.ownerOrgObjectLinkID = OrgObjectLink.orgObjectLinkID 
  AND CaseHeader.statusCode = :caseStatus