USP_AWARDMANAGEMENTINTEGRATIONPROCESS_GETPARAMETERS

      create procedure dbo.USP_AWARDMANAGEMENTINTEGRATIONPROCESS_GETPARAMETERS
      (
        @ID uniqueidentifier = null
      )    
      as
        set nocount on;

        select 
          AWARDMANAGEMENTINTEGRATIONPROCESS.INTEGRATIONTYPECODE
        from 
          dbo.AWARDMANAGEMENTINTEGRATIONPROCESS
        where 
          AWARDMANAGEMENTINTEGRATIONPROCESS.ID = @ID;