USP_KPI_COMMITTEE_FUNDRAISINGGOALAMOUNTTOTAL

Parameters

Parameter	Parameter Type	Mode
@VALUE	money	INOUT
@ASOFDATE	datetime	IN
@COMMITTEEID	uniqueidentifier	IN
@GROUPGOALID	uniqueidentifier	IN
@BASECURRENCYID	uniqueidentifier	IN

Definition

Copy



                    CREATE procedure dbo.USP_KPI_COMMITTEE_FUNDRAISINGGOALAMOUNTTOTAL(
                        @VALUE money output,
                        @ASOFDATE datetime,
                        @COMMITTEEID uniqueidentifier,
                        @GROUPGOALID uniqueidentifier,
                        @BASECURRENCYID uniqueidentifier = null
                    ) as begin
                        set nocount on;

                            set @VALUE = 0;

                            if @BASECURRENCYID is null
                                set @BASECURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

                            select
                                @VALUE = dbo.UFN_REVENUESOLICITOR_GETSUM_INCURRENCY(@COMMITTEEID, STARTDATE, GOALDATE, @BASECURRENCYID)
                            from 
                                dbo.GROUPGOAL
                            where
                                GROUPGOAL.ID = @GROUPGOALID
                    end