Operation Details
Description: Returns a list of the active issues related to the given case ID.
Sterotype: nsmulti
SQL 
SELECT 
CaseHeader.startDate,
IssueDelivery.issueType

INTO
:startDate,
:issueType

FROM 
IssueDelivery, 
CaseHeader

WHERE
IssueDelivery.relatedCaseID = :relatedCaseID AND
IssueDelivery.caseID = CaseHeader.caseID AND
CaseHeader.statusCode <> :closedCaseStatus AND
CaseHeader.statusCode <> :cancelledCaseStatus AND
(IssueDelivery.resolutionStatus IS NULL OR IssueDelivery.resolutionStatus <> :resolutionCancelledCode)