UFN_SITEID_MAPFROM_ASSIGNPLANNEDGIFTLETTERCODESPROCESSID

Map a ASSIGNPLANNEDGIFTLETTERCODESPROCESSID to multiple SITEIDs

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ASSIGNPLANNEDGIFTLETTERCODESPROCESSID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SITEID_MAPFROM_ASSIGNPLANNEDGIFTLETTERCODESPROCESSID(
                @ASSIGNPLANNEDGIFTLETTERCODESPROCESSID uniqueidentifier
            ) 
            returns @SITES table (SITEID uniqueidentifier)
            as
            begin

                insert into @SITES(
                    SITEID
                )
                select
                    SITEID
                from dbo.UFN_BUSINESSPROCESSPARAMETERSET_GETSITES(@ASSIGNPLANNEDGIFTLETTERCODESPROCESSID);

                return;
            end