Operation Details
Description: Retrieves the case reference, case type and concern role name.
Sterotype: ns
SQL 
SELECT
  CaseHeader.caseReference,
  CaseHeader.integratedCaseType,
  ConcernRole.concernRoleName,
  ConcernRole.primaryAlternateID
INTO
  :caseReference,
  :integratedCaseType,
  :concernRoleName,
  :primaryAlternateID 
FROM
  ConcernRole,
  CaseHeader 
WHERE CaseHeader.caseID = :caseID 
  AND ConcernRole.concernRoleID = CaseHeader.concernRoleID