Operation Details |
Description: | To retrieve the country code which corresponds to the primary address ID. |
Sterotype: | ns |
SQL |
SELECT Address.countryCode INTO :countryCode FROM Address, ConcernRole WHERE ConcernRole.concernRoleID = :concernRoleID AND Address.addressID = ConcernRole.primaryAddressID |