| Operation Details |  |
| Description: | Returns a concern role name and address details. |
| Sterotype: | ns |
| SQL | |
SELECT concernRoleName, concernRoleType, addressData INTO :fullName, :concernRoleTypeCode, :addressData FROM ConcernRole, Address WHERE ConcernRole.concernRoleID = :concernRoleID AND Address.addressID = ConcernRole.primaryAddressID |