USP_STEWARDSHIPPACKAGEPROCESS_GETPARAMETERS

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

                select 
                    [STEWARDSHIPPACKAGEPROCESS].[NAME], 
                    [BUSINESSPROCESSVIEW].[ID] as [OUTPUTVIEWID],
                    [STEWARDSHIPPACKAGEPROCESS].[CREATEOUTPUTIDSET], 
                    [STEWARDSHIPPACKAGEPROCESS].[OUTPUTIDSETNAME], 
                    [STEWARDSHIPPACKAGEPROCESS].[OVERWRITEOUTPUTIDSET],
                    [STEWARDSHIPPACKAGEPROCESS].[WORDFILE],                                                        
                    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,
                    [STEWARDSHIPPACKAGEPROCESS].[CUSTOMPARAMETERDATAFORMITEM]
                from 
                    dbo.STEWARDSHIPPACKAGEPROCESS 
                        inner join dbo.BUSINESSPROCESSVIEW on STEWARDSHIPPACKAGEPROCESS.BUSINESSPROCESSVIEWID = BUSINESSPROCESSVIEW.ID            
                        left outer join dbo.BUSINESSPROCESSCOMMPREF on STEWARDSHIPPACKAGEPROCESS.ID = BUSINESSPROCESSCOMMPREF.BUSINESSPROCESSPARAMETERSETID
                where 
                    [STEWARDSHIPPACKAGEPROCESS].ID = @ID;