USP_BBNC_GETTRANSACTIONPROCESSOR_1_3

            CREATE procedure dbo.USP_BBNC_GETTRANSACTIONPROCESSOR_1_3(@ID uniqueidentifier)
            as

            set nocount on;            

            select 
            NCTP.ID, 
            NCTP.[NAME],
            NCTP.BATCHTEMPLATEID,
            NCTP.ASSEMBLYNAME,
            NCTP.CLASSNAME,
            NCTP.ISACTIVEPROCESSOR,
            NCTP.MAXTRANSACTIONSPERBATCH,
            (select INCLUDETRANSACTIONTYPECODE 
              from NETCOMMUNITYMAPPINGRULE where NETCOMMUNITYTRANSACTIONPROCESSORID = @ID 
                                              and MAPPINGTYPECODE = 0) as INCLUDETRANSACTIONTYPECODE 
            from dbo.NETCOMMUNITYTRANSACTIONPROCESSOR NCTP
            where NCTP.ID = @ID;