UFN_QUERY_STEWARDSHIPPACKAGEPROCESSOUTPUT

                CREATE function [dbo].[UFN_QUERY_STEWARDSHIPPACKAGEPROCESSOUTPUT]
                (
                    @NAMEFORMATPARAMETERID uniqueidentifier,
                    @ADDRESSPROCESSINGOPTIONID uniqueidentifier,
                    @PARAMETERSETID uniqueidentifier = null,
            @CURRENTAPPUSERID uniqueidentifier = null
                )
                returns table
                as
                return 
                (                
                select
                    D.ID as ID,                     
                    C.ID as CONSTITUENTID,
                    D.NAME as NAME,
                    D.DESCRIPTION as DESCRIPTION,
                    D.VANITYNAME as VANITYNAME,
                    D.STATEMENTWORDING as STATEMENTWORDING,
                    SPP.ID as PACKAGEID,
                    SPP.NAME as PACKAGENAME,
                    C.LOOKUPID as LOOKUPID,
                    C.NAME as CONSTITUENTNAME,    
                    A.ADDRESSEE,    
                    A.SALUTATION,
                    A.CONTACT as CONTACTADDRESSEE,
                    A.POSITION,
                    A.ADDRESSBLOCK,
                    A.CITY,
                    A.STATE,
                    A.POSTCODE,
                    A.COUNTRY
                from
                    dbo.UFN_DESIGNATIONLEVEL_GETSTEWARDSHIPRECIPIENTS(@PARAMETERSETID, @CURRENTAPPUSERID) S 
                    inner join dbo.CONSTITUENT C on S.CONSTITUENTID = C.ID
                    inner join DESIGNATIONLEVEL D on D.ID = @PARAMETERSETID
                    inner join dbo.UFN_CONTACTPREFERENCES_GETFORMATS(@NAMEFORMATPARAMETERID,@ADDRESSPROCESSINGOPTIONID,8,@PARAMETERSETID,null,0) as A on C.ID = A.CONSTITUENTID                    
                    left outer join dbo.STEWARDSHIPPACKAGEPROCESS SPP on D.STEWARDSHIPPACKAGEPROCESSID = SPP.ID
            )