Operation Details
Description: Retrieves the case type concern role and the concern role type.
Sterotype: ns
SQL 
SELECT
  CaseHeader.caseTypeCode,
  CaseHeader.concernRoleID,
  ConcernRole.concernRoleType
INTO
  :caseTypeCode,
  :concernRoleID,
  :concernRoleType 
FROM
  CaseHeader,
  ConcernRole 
WHERE CaseHeader.caseID = :caseID 
  AND ConcernRole.concernRoleID = CaseHeader.concernRoleID