| Operation Details |  |
| Description: | Retrieves a list of web address records for the concern role. |
| Sterotype: | nsmulti |
| SQL | |
SELECT typeCode, webAddress, startDate, endDate, statusCode, concernRoleWebAddressID, ConcernRoleWebAddress.webAddressID, webAddress.versionNo, ConcernRoleWebAddress.versionNo INTO :typeCode, :webAddress, :startDate, :endDate, :statusCode, :concernRoleWebAddressID, :webAddressID, :webAddressVersionNo, :concernRoleWebAddressVersionNo FROM webAddress, ConcernRoleWebAddress WHERE concernRoleID = :concernRoleID AND webAddress.webAddressID = ConcernRoleWebAddress.webAddressID |