Operation Details
Description: Searches existing programs of type "closed" on the Integrated Case. Returns a list of caseIDs.
Sterotype: nsmulti
SQL 
SELECT
  CaseHeader.caseID,
  CaseHeader.endDate
INTO
  :caseID,
  :endDate 
FROM
  CaseHeader,
  ProductDelivery 
WHERE CaseHeader.integratedCaseID = :caseID 
  AND CaseHeader.caseID = ProductDelivery.caseID 
  AND ProductDelivery.productType = :productType 
  AND ProductDelivery.productID = :productID 
  AND CaseHeader.statusCode = :statusCode