USP_DATAFORMTEMPLATE_ADDLOAD_APPEALMAILINGSETUP

CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADDLOAD_APPEALMAILINGSETUP
(
    @CURRENTAPPUSERID uniqueidentifier
)
as
begin
    declare @CONSTITUENTRECORDTYPEID uniqueidentifier;
    select @CONSTITUENTRECORDTYPEID = [ID] from dbo.[RECORDTYPE] where upper([NAME]) = 'CONSTITUENT';

    select
        @CONSTITUENTRECORDTYPEID as CONSTITUENTRECORDTYPEID,
        (select [NAME] as GROUPNAME from dbo.[UFN_SELECTION_GETGROUPNAMES](@CONSTITUENTRECORDTYPEID) for xml raw('ITEM'),type,elements,root('SELECTIONLISTS'),binary base64) as SELECTIONLISTS,
        dbo.[UFN_MKTSEGMENTATION_GETREQUIREDANDDEFAULTSOLICITCODEEXCLUSIONS_TOITEMLISTXML](@CURRENTAPPUSERID) as SELECTEDEXCLUSIONS,
        (select top(1) [ID] from dbo.[ADDRESSPROCESSINGOPTION] where [ISDEFAULT] = 1 and dbo.[UFN_SITEALLOWEDFORUSER](@CURRENTAPPUSERID, [SITEID]) = 1) as ADDRESSPROCESSINGOPTIONID,
        (select top(1) [ID] from dbo.[NAMEFORMATPARAMETER] where [ISDEFAULT] = 1 and dbo.[UFN_SITEALLOWEDFORUSER](@CURRENTAPPUSERID, [SITEID]) = 1) as NAMEFORMATPARAMETERID
end