Operation Details
Description: Method will return a list of details of concern role addresses with a given address ID
Sterotype: nsmulti
SQL 
SELECT
  typeCode,
  addressData,
  startDate,
  endDate,
  ConcernRoleAddress.statusCode,
  concernRoleAddressID,
  Address.addressID,
  Address.versionNo,
  ConcernRoleAddress.versionNo
INTO
  :typeCode,
  :addressData,
  :startDate,
  :endDate,
  :statusCode,
  :concernRoleAddressID,
  :addressID,
  :addressVersionNo,
  :concernRoleAddressVersionNo 
FROM
  Address,
  ConcernRoleAddress 
WHERE Address.addressID = ConcernRoleAddress.addressID 
  AND ConcernRoleAddress.addressID = :addressID