UFN_BUSINESSPROCESSCOMMPREF_GETINCLUDEDCONSTITUENT

            CREATE function [dbo].[UFN_BUSINESSPROCESSCOMMPREF_GETINCLUDEDCONSTITUENT]
            (
                @ASOFDATE datetime, 
                @EXCLUDEDECEASED bit = 0, 
                @EXCLUDEINACTIVE bit = 0, 
                @INCLUSIONS xml, 
                @EXCLUSIONS xml
                --@OVERRIDEREQUIREDEXCLUSIONS bit = 0,

                --@REQUIREDEXCLUSIONS xml = null

            ) 
            returns table
                as
                return
                    select 
                        CONSTITUENT.ID 
                    from 
                        dbo.CONSTITUENT
                    where not exists
                        (select 
                            CONSTITUENTSOLICITCODE.CONSTITUENTID
                        from 
                            dbo.SOLICITCODE 
                            left join dbo.UFN_BUSINESSPROCESSCOMMPREF_GETEXCLUSIONS_FROMITEMLISTXML(@EXCLUSIONS) as NOTREQUIREDEXCLUSIONS on (SOLICITCODE.ID = NOTREQUIREDEXCLUSIONS.SOLICITCODEID)
                            inner join dbo.CONSTITUENTSOLICITCODE ON SOLICITCODE.ID = CONSTITUENTSOLICITCODE.SOLICITCODEID
                        where 
                            CONSTITUENTSOLICITCODE.CONSTITUENTID = CONSTITUENT.ID and
                            (SOLICITCODE.EXCLUSIONCODE = 2 or NOTREQUIREDEXCLUSIONS.SOLICITCODEID is not null) and
                            ((@ASOFDATE is null) or (@ASOFDATE between coalesce(STARTDATE, @ASOFDATE) and coalesce(ENDDATE, @ASOFDATE)))
                        )
                        and (@EXCLUDEINACTIVE=0 or CONSTITUENT.ISINACTIVE=0)
                        and (@EXCLUDEDECEASED=0 or not exists(select ID from DECEASEDCONSTITUENT where ID = CONSTITUENT.ID))