USP_PLANNEDGIFTACKNOWLEDGEMENTPROCESS_GETPARAMETERS

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

                select 
                    PLANNEDGIFTACKNOWLEDGEMENTPROCESS.NAME, 
                    PLANNEDGIFTACKNOWLEDGEMENTPROCESS.IDSETREGISTERID, 
                    PLANNEDGIFTACKNOWLEDGEMENTPROCESS.CREATEOUTPUTIDSET, 
                    PLANNEDGIFTACKNOWLEDGEMENTPROCESS.OUTPUTIDSETRECORDTYPEID, 
                    PLANNEDGIFTACKNOWLEDGEMENTPROCESS.OUTPUTIDSETNAME, 
                    PLANNEDGIFTACKNOWLEDGEMENTPROCESS.OVERWRITEOUTPUTIDSET, 
                    PLANNEDGIFTACKNOWLEDGEMENTPROCESS.PLANNEDGIFTLETTERCODEID,
                    PLANNEDGIFTACKNOWLEDGEMENTPROCESS.MARKLETTERSACKNOWLEDGED,
                    case 
                        when PLANNEDGIFTACKNOWLEDGEMENTPROCESS.ACKNOWLEDGEDATETYPECODE = 0 
                            then dbo.UFN_DATE_GETEARLIESTTIME(getdate()) 
                        else PLANNEDGIFTACKNOWLEDGEMENTPROCESS.ACKNOWLEDGEDATE 
                    end 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,
                    PLANNEDGIFTLETTERCODE.CUSTOMPARAMETERDATAFORMITEM,
                    PLANNEDGIFTLETTERCODE.EXPORTDEFINITIONID
                from 
                    dbo.PLANNEDGIFTACKNOWLEDGEMENTPROCESS 
                inner join
                    dbo.PLANNEDGIFTLETTERCODE on PLANNEDGIFTACKNOWLEDGEMENTPROCESS.PLANNEDGIFTLETTERCODEID = PLANNEDGIFTLETTERCODE.ID
                left join
                    dbo.BUSINESSPROCESSVIEW on PLANNEDGIFTLETTERCODE.QUERYVIEWID = BUSINESSPROCESSVIEW.QUERYVIEWCATALOGID
                left outer join dbo.BUSINESSPROCESSCOMMPREF on PLANNEDGIFTACKNOWLEDGEMENTPROCESS.ID = BUSINESSPROCESSCOMMPREF.BUSINESSPROCESSPARAMETERSETID
                left join 
                    dbo.EXPORTDEFINITION on PLANNEDGIFTLETTERCODE.EXPORTDEFINITIONID = EXPORTDEFINITION.ID
                where 
                    PLANNEDGIFTACKNOWLEDGEMENTPROCESS.ID = @ID;