Operation Details
Description: Returns the name of the concern role to whom the case is being delivered.
Sterotype: ns
SQL 
SELECT
  ConcernRole.concernRoleName,
  CaseHeader.caseReference
INTO
  :concernRoleName,
  :caseReference 
FROM
  ConcernRole,
  CaseHeader 
WHERE CaseHeader.caseID = :caseID 
  AND ConcernRole.concernRoleID = CaseHeader.concernRoleID