USP_TRIBUTEACKNOWLEDGEMENTPROCESS_GETPARAMETERS

            CREATE procedure dbo.USP_TRIBUTEACKNOWLEDGEMENTPROCESS_GETPARAMETERS
            (
                @ID uniqueidentifier
            )
            as
                set nocount on;

                select 
                    TRIBUTEACKNOWLEDGEMENTPROCESS.NAME, 
                    TRIBUTEACKNOWLEDGEMENTPROCESS.IDSETREGISTERID, 
                    TRIBUTEACKNOWLEDGEMENTPROCESS.CREATEOUTPUTIDSET, 
                    TRIBUTEACKNOWLEDGEMENTPROCESS.OUTPUTIDSETRECORDTYPEID, 
                    TRIBUTEACKNOWLEDGEMENTPROCESS.OUTPUTIDSETNAME, 
                    TRIBUTEACKNOWLEDGEMENTPROCESS.OVERWRITEOUTPUTIDSET, 
                    TRIBUTEACKNOWLEDGEMENTPROCESS.TRIBUTELETTERCODEID,
                    TRIBUTEACKNOWLEDGEMENTPROCESS.MARKLETTERSACKNOWLEDGED,
                    TRIBUTEACKNOWLEDGEMENTPROCESS.ACKNOWLEDGEDATETYPECODE,
                    TRIBUTEACKNOWLEDGEMENTPROCESS.ACKNOWLEDGEDATE,
                    BUSINESSPROCESSVIEW.ID as OUTPUTVIEWID,
                    convert(bit, case when exists(select * from dbo.BUSINESSPROCESSCOMMPREFINCLUSIONS where BUSINESSPROCESSPARAMETERSETID=@id) then 1 else 0 end) 'INCLUSION',
                    convert(bit, case when exists(select * from dbo.BUSINESSPROCESSCOMMPREFEXCLUSIONS where BUSINESSPROCESSPARAMETERSETID=@id) then 1 else 0 end) 'EXCLUSION',
                    BUSINESSPROCESSCOMMPREF.DATETYPECODE as EXCLUSIONDATETYPECODE,
                    BUSINESSPROCESSCOMMPREF.ASOFDATE,
                    BUSINESSPROCESSCOMMPREF.EXCLUDEDECEASED,
                    BUSINESSPROCESSCOMMPREF.EXCLUDEINACTIVE,
                    TRIBUTELETTERCODE.CUSTOMPARAMETERDATAFORMITEM,
                    TRIBUTELETTERCODE.EXPORTDEFINITIONID,
                    (select top 1 NAMEFORMATPARAMETER.ID from dbo.NAMEFORMATPARAMETER where ISDEFAULT = 1) as [DEFAULTNAMEFORMATPARAMETERID],
                    (select top 1 ADDRESSPROCESSINGOPTION.ID from dbo.ADDRESSPROCESSINGOPTION where ISDEFAULT = 1) as [DEFAULTADDRESSPROCESSINGOPTIONID]
                from 
                    dbo.TRIBUTEACKNOWLEDGEMENTPROCESS 
                inner join
                    dbo.TRIBUTELETTERCODE on TRIBUTEACKNOWLEDGEMENTPROCESS.TRIBUTELETTERCODEID = TRIBUTELETTERCODE.ID
                left join
                    dbo.BUSINESSPROCESSVIEW on TRIBUTELETTERCODE.QUERYVIEWID = BUSINESSPROCESSVIEW.QUERYVIEWCATALOGID
                left outer join dbo.BUSINESSPROCESSCOMMPREF on TRIBUTEACKNOWLEDGEMENTPROCESS.ID = BUSINESSPROCESSCOMMPREF.BUSINESSPROCESSPARAMETERSETID
                where 
                    TRIBUTEACKNOWLEDGEMENTPROCESS.ID = @ID;