| Operation Details |  |
| Description: | Reads case reference, concern role name and concern role primary client ID. |
| Sterotype: | ns |
| SQL | |
SELECT CaseHeader.caseReference, ConcernRole.concernRoleName, ConcernRole.primaryAlternateID INTO :caseReference, :concernRoleName, :primaryAlternateID FROM CaseHeader, ConcernRole WHERE CaseHeader.caseID = :caseID AND ConcernRole.concernRoleID = CaseHeader.concernRoleID |