Operation Details
Description: Searches for programs with one of these statuses: open, approved, rejected, active, superseded.
Sterotype: nsmulti
SQL 
SELECT
  CaseHeader.caseID
INTO
  :caseID 
FROM
  CaseHeader,
  ProductDelivery 
WHERE CaseHeader.integratedCaseID = :caseID 
  AND CaseHeader.caseID = ProductDelivery.caseID 
  AND ProductDelivery.productType = :productType 
  AND ProductDelivery.productID = :productID 
  AND 
  (
    CaseHeader.statusCode = :statusCode1 
    OR CaseHeader.statusCode = :statusCode2 
    OR CaseHeader.statusCode = :statusCode3 
    OR CaseHeader.statusCode = :statusCode4 
    OR CaseHeader.statusCode = :statusCode5 
  )