SELECT   COUNT(*) 
INTO  
 :numberOfRecords  
FROM  
 CaseHeader, CaseClosure
 WHERE 
 CaseHeader.statusCode = :statusCode
  AND CaseClosure.caseID = CaseHeader.caseID
AND CaseClosure.closureDate > :closureDate 
AND CaseClosure.closureDate =CaseHeader.endDate;