| Operation Details |  |
| Description: | Returns the concern role address details based on the concern role id. |
| Sterotype: | ns |
| SQL | |
SELECT cra.concernRoleAddressID, cra.endDate, cra.statusCode INTO :concernRoleAddressID, :endDate, :statusCode FROM ConcernRole cr, ConcernRoleAddress cra WHERE cr.primaryAddressID = cra.addressID AND cr.concernRoleID = cra.concernRoleID AND cr.concernRoleID = :concernRoleID |