Operation Details
Description: This method retrieves a list of details for addresses of the specified concern role with a specific status.
Sterotype: nsmulti
SQL 
SELECT
  typeCode,
  addressData,
  startDate,
  endDate,
  ConcernRoleAddress.statusCode,
  concernRoleAddressID,
  Address.addressID,
  Address.versionNo,
  ConcernRoleAddress.versionNo,
  Address.latitude,
  Address.longitude
INTO
  :typeCode,
  :addressData,
  :startDate,
  :endDate,
  :statusCode,
  :concernRoleAddressID,
  :addressID,
  :addressVersionNo,
  :concernRoleAddressVersionNo,
  :latitudeOpt,
  :longitudeOpt
FROM
  Address,
  ConcernRoleAddress 
WHERE concernRoleID = :concernRoleID 
  AND Address.addressID = ConcernRoleAddress.addressID 
  AND ConcernRoleAddress.statusCode = :statusCode