| Operation Details |  |
| Description: | Returns a list of active case deduction items for a case nominee. |
| Sterotype: | nsmulti |
| SQL | |
SELECT
deductionName,
category
INTO
:deductionName,
:category
FROM
CaseDeductionItem
WHERE caseNomineeID = :caseNomineeID
AND statusCode = :statusCode
AND
(
endDate is NULL
OR endDate >= :endDate
)
|