Operation Details
Description: Returns concern role address and name details for concern role id.
Sterotype: nsmulti
SQL 
SELECT
  ConcernRoleAddress.concernRoleAddressID,
  AlternateName.alternateNameID,
  AlternateName.firstForename,
  AlternateName.surname,
  ConcernRole.concernRoleID,
  ConcernRoleAddress.addressData,
  ConcernRole.concernRoleName,
  AlternateName.phoneticEncoding
INTO
  :concernRoleAddressID,
  :alternateNameID,
  :firstName,
  :surname,
  :concernRoleID,
  :addressData,
  :concernRoleName,
  :phoneticEncoding
FROM
  ConcernRole LEFT OUTER JOIN 
  (
    SELECT 
      ConcernRoleAddress.concernRoleAddressID, 
      ConcernRoleAddress.concernRoleID, 
      Address.addressData
    FROM
      ConcernRoleAddress, Address
    WHERE ConcernRoleAddress.addressID = Address.addressID
    AND ConcernRoleAddress.statusCode = :statusCode
  ) ConcernRoleAddress ON ConcernRole.concernRoleID = ConcernRoleAddress.concernRoleID LEFT OUTER JOIN
  (
    SELECT 
      AlternateName.alternateNameID,
      AlternateName.firstForename,
      AlternateName.surname,
      AlternateName.phoneticEncoding,
      AlternateName.concernRoleID
    FROM
      AlternateName
    WHERE AlternateName.nameStatus = :statusCode
  ) AlternateName ON ConcernRole.concernRoleID = AlternateName.concernRoleID
WHERE
  ConcernRole.concernRoleID = :concernRoleID