UFN_FUNDINGREQUESTOUTLINE_STEPSFORFUNDINGPLAN

Returns steps from a funding request outline for use on a specific funding plan's request.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@FUNDINGREQUESTOUTLINEID	uniqueidentifier	IN
@FUNDINGPLANID	uniqueidentifier	IN
@BASEDATE	datetime	IN

Definition

Copy



            CREATE function dbo.UFN_FUNDINGREQUESTOUTLINE_STEPSFORFUNDINGPLAN(
                @FUNDINGREQUESTOUTLINEID uniqueidentifier, 
                @FUNDINGPLANID uniqueidentifier, 
                @BASEDATE datetime
            )
            returns @RET table (
                FUNDINGREQUESTOUTLINESTEPID uniqueidentifier,
                OBJECTIVE nvarchar(100),
                OWNERID uniqueidentifier,
                FUNDINGREQUESTSTAGECODEID uniqueidentifier,
                EXPECTEDDATE datetime,
                INTERACTIONTYPECODEID uniqueidentifier
            )
            with execute as caller
            as begin
                declare @FUNDINGPLANMANAGERID uniqueidentifier;
                select @FUNDINGPLANMANAGERID = FUNDINGPLANMANAGERID from dbo.FUNDINGPLAN where ID=@FUNDINGPLANID;

                insert into @RET
                select 
                    ID,
                    OBJECTIVE, 
                    case FUNDRAISERROLECODE when 0 then @FUNDINGPLANMANAGERID else null end,
                    FUNDINGREQUESTSTAGECODEID, 
                    dateadd(day, DATEOFFSET, dbo.UFN_DATE_GETEARLIESTTIME(@BASEDATE)),
                    INTERACTIONTYPECODEID
                from 
                    dbo.FUNDINGREQUESTOUTLINESTEP
                where 
                    FUNDINGREQUESTOUTLINEID=@FUNDINGREQUESTOUTLINEID;

                return;
            end