Operation Details
Description: Retrieves the reference number.
Sterotype: nsmulti
SQL 
SELECT
  ConcernRoleAlternateID.concernRoleID,
  ConcernRoleAlternateID.alternateID,
  concernRoleType
INTO
  :concernRoleID,
  :alternateID,
  :concernRoleType 
FROM
  ConcernRoleAlternateID,
  ConcernRole 
WHERE ConcernRoleAlternateID.concernRoleID = ConcernRole.concernRoleID 
  AND typeCode = :typeCode 
  AND ConcernRoleAlternateID.statusCode = :statusCode 
  AND ConcernRoleAlternateID.alternateID = :alternateID