Operation Details
Description: This method retrieves a list of details for addresses of a specified status and type for the specified concern role.
Sterotype: nsmulti
SQL 
SELECT
  ConcernRoleAddress.typeCode,
  Address.addressData,
  ConcernRoleAddress.concernRoleAddressID,
  Address.addressID
INTO
  :typeCode,
  :addressData,
  :concernRoleAddressID,
  :addressID 
FROM
  Address,
  ConcernRoleAddress 
WHERE ConcernRoleAddress.concernRoleID = :concernRoleID 
  AND ConcernRoleAddress.typeCode = :typeCode 
  AND ConcernRoleAddress.statusCode = :statusCode 
  AND Address.addressID = ConcernRoleAddress.addressID