| Operation Details |  |
| Description: | Searches the active cases for a concern role id |
| Sterotype: | nsmulti |
| SQL | |
SELECT caseID, startDate, expectedEndDate INTO :caseID, :startDate, :endDate FROM CaseHeader WHERE statusCode = :statusCode AND concernRoleID = :concernRoleID |