| Operation Details |  |
| Description: | returns the list of currently active clients for an Integrated case. |
| Sterotype: | nsmulti |
| SQL | |
SELECT
caseID,
concernRoleID,
typeCode
INTO
:caseID,
:concernRoleID,
:typeCode
FROM
ConcernCaseRole
WHERE caseID = :caseID
AND recordStatus = :recordStatus
AND
(
endDate >= :startDate
OR endDate IS NULL
)
|