Operation Details
Description: Method to return a list of all Concern Role Address Snapshot records for a concernRoleAddressID.
Sterotype: nsmulti
SQL 
SELECT
  concernRoleAddressSnapshotID,
  concernRoleID,
  ConcernRoleAddressSnapshot.addressID,
  addressData,
  concernRoleAddressID,
  typeCode,
  startDate,
  endDate,
  statusCode,
  creationDateTime
INTO
  :concernRoleAddressSnapshotID,
  :concernRoleID,
  :addressID,
  :addressData,
  :concernRoleAddressID,
  :typeCode,
  :startDate,
  :endDate,
  :statusCode,
  :creationDateTime 
FROM
  ConcernRoleAddressSnapshot,
  Address 
WHERE concernRoleAddressID = :concernRoleAddressID 
  AND Address.addressID = ConcernRoleAddressSnapshot.addressID 
ORDER BY creationDateTime DESC