Operation Details
Description: Retrieves the user name of the current case supervisor
Sterotype: ns
SQL 
SELECT
  CaseUserRole.orgObjectLinkID,
  CaseHeader.caseReference
INTO
  :orgObjectLinkID,
  :caseReference 
FROM
  CaseUserRole,
  CaseHeader 
WHERE CaseHeader.caseID = CaseUserRole.caseID 
  AND CaseUserRole.caseID = :caseID 
  AND CaseUserRole.recordStatus = :statusCode 
  AND CaseUserRole.typeCode = :typeCode