Operation Details |
Description: | Reads the concern role details of the provider. |
Sterotype: | ns |
SQL |
SELECT ConcernRole.concernRoleID, ConcernRole.concernRoleName, ConcernRole.concernRoleType INTO :providerConcernRoleID, :providerName, :concernRoleType FROM Provider, ConcernRole WHERE Provider.providerConcernRoleID = :providerConcernRoleID AND Provider.providerConcernRoleID = ConcernRole.concernRoleID |