UFN_ASSIGNPLANNEDGIFTLETTERCODESPROCESS_GETLETTERCODESANDSELECTIONS

Returns all letter codes and their corresponding selections for a given assign letter codes process.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ASSIGNPLANNEDGIFTLETTERCODESPROCESSID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_ASSIGNPLANNEDGIFTLETTERCODESPROCESS_GETLETTERCODESANDSELECTIONS
            (
                @ASSIGNPLANNEDGIFTLETTERCODESPROCESSID uniqueidentifier = null
            )
            returns @RESULT table
            (
                PLANNEDGIFTLETTERCODEID uniqueidentifier,
                IDSETREGISTERID uniqueidentifier
            )
            as
            begin

                declare @OWNERID uniqueidentifier;
                set @OWNERID = (select OWNERID from dbo.BUSINESSPROCESSINSTANCE where BUSINESSPROCESSPARAMETERSETID = @ASSIGNPLANNEDGIFTLETTERCODESPROCESSID);

                insert into @RESULT
                select
                    PLANNEDGIFTLETTERCODEID,
                    IDSETREGISTERID
                from
                    dbo.UFN_ASSIGNPLANNEDGIFTLETTERCODESPROCESS_GETLETTERCODESANDSELECTIONS_SITES(@ASSIGNPLANNEDGIFTLETTERCODESPROCESSID, @OWNERID);

                return;

            end