USP_AWARDMANAGEMENTCONFIGURATION_GET

      create procedure dbo.USP_AWARDMANAGEMENTCONFIGURATION_GET
      (
        @AWARDMANAGEMENTTOKEN nvarchar(100) = null output,
        @AWARDMANAGEMENTURL nvarchar(2047) = null output
      )
      as
        set nocount on;

        select
          @AWARDMANAGEMENTTOKEN = AWARDMANAGEMENTTOKEN,
          @AWARDMANAGEMENTURL = AWARDMANAGEMENTURL
        from dbo.AWARDMANAGEMENTCONFIGURATION;