Operation Details
Description: Return events by caseID that are not canceled.
Sterotype: nsmulti
SQL 
SELECT
  caseEventID,
  caseID,
  relatedID,
  eventTypeCode,
  startDate,
  endDate,
  statusCode,
  recordStatus,
  versionNo
INTO
  :caseEventID,
  :caseID,
  :relatedID,
  :eventTypeCode,
  :startDate,
  :endDate,
  :statusCode,
  :recordStatus,
  :versionNo 
FROM
  CaseEvent 
WHERE caseID = :caseID 
  AND statusCode <> :statusCode