Operation Details |
Description: | This method retrieves a list of details for all addresses of the specified concern role. |
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 concernRoleID = :concernRoleID AND Address.addressID = ConcernRoleAddress.addressID |