Operation Details
Description: Returns the number of certifications for a case that are active and who's from date is before the date entered.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :numberOfRecords 
FROM
  ProductDeliveryCertDiary 
WHERE caseID = :caseID 
  AND periodFromDate < :startDate 
  AND statusCode = :statusCode