USP_ACKNOWLEDGEMENTPROCESS_GETPARAMETERS

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

                select 
                    [ACKNOWLEDGEMENTPROCESS].[NAME], 
                    [ACKNOWLEDGEMENTPROCESS].[IDSETREGISTERID], 
                    [ACKNOWLEDGEMENTPROCESS].[CREATEOUTPUTIDSET], 
                    [ACKNOWLEDGEMENTPROCESS].[OUTPUTIDSETRECORDTYPEID], 
                    [ACKNOWLEDGEMENTPROCESS].[OUTPUTIDSETNAME], 
                    [ACKNOWLEDGEMENTPROCESS].[OVERWRITEOUTPUTIDSET], 
                    [ACKNOWLEDGEMENTPROCESS].[LETTERCODEID],
                    [ACKNOWLEDGEMENTPROCESS].[MARKLETTERSACKNOWLEDGED],
                    [ACKNOWLEDGEMENTPROCESS].[ACKNOWLEDGEDATETYPECODE],
                    [ACKNOWLEDGEMENTPROCESS].[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,
                    LETTERCODE.CUSTOMPARAMETERDATAFORMITEM,
                    LETTERCODE.EXPORTDEFINITIONID
                from 
                    dbo.ACKNOWLEDGEMENTPROCESS 
                inner join
                    dbo.LETTERCODE on ACKNOWLEDGEMENTPROCESS.LETTERCODEID = LETTERCODE.ID
                left join
                    dbo.BUSINESSPROCESSVIEW on LETTERCODE.QUERYVIEWID = BUSINESSPROCESSVIEW.QUERYVIEWCATALOGID
                left outer join dbo.BUSINESSPROCESSCOMMPREF on ACKNOWLEDGEMENTPROCESS.ID = BUSINESSPROCESSCOMMPREF.BUSINESSPROCESSPARAMETERSETID
                where 
                    ACKNOWLEDGEMENTPROCESS.ID = @ID;