USP_KPI_DESIGNATIONLEVEL_GOALREVENUETOTAL

Parameters

Parameter	Parameter Type	Mode
@VALUE	money	INOUT
@DESIGNATIONLEVELID	uniqueidentifier	IN
@DESIGNATIONLEVELGOALID	uniqueidentifier	IN
@ASOFDATE	datetime	IN
@ORGPOSITIONSSELECTIONID	uniqueidentifier	IN
@CURRENCYID	uniqueidentifier	IN

Definition

Copy



                CREATE procedure dbo.USP_KPI_DESIGNATIONLEVEL_GOALREVENUETOTAL

                @VALUE money output,
                @DESIGNATIONLEVELID uniqueidentifier,
                @DESIGNATIONLEVELGOALID uniqueidentifier,
                @ASOFDATE datetime,
                @ORGPOSITIONSSELECTIONID uniqueidentifier = null,
                @CURRENCYID uniqueidentifier = null

                as

                set nocount on;

                declare @STARTDATE datetime;
                declare @ENDDATE datetime;
                declare @PLEDGEBALANCE money;
                declare @TOTALRECEIVED money;

                select @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(STARTDATE)
                from dbo.DESIGNATIONLEVELGOAL
                where DESIGNATIONLEVELGOAL.ID = @DESIGNATIONLEVELGOALID;

                select @CURRENCYID = BASECURRENCYID
                from dbo.DESIGNATIONLEVEL
                where DESIGNATIONLEVEL.ID = @DESIGNATIONLEVELID;

                set @ENDDATE = dbo.UFN_DATE_GETLATESTTIME(@ASOFDATE);

                exec dbo.USP_DESIGNATIONLEVEL_GETPLEDGEBALANCEBYPOSITIONINCURRENCY @PLEDGEBALANCE output,@DESIGNATIONLEVELID,@ORGPOSITIONSSELECTIONID,@STARTDATE,@ASOFDATE,@CURRENCYID;
                exec dbo.USP_DESIGNATIONLEVEL_GETTOTALRECEIVEDBYPOSITIONINCURRENCY @TOTALRECEIVED output,@DESIGNATIONLEVELID,@ORGPOSITIONSSELECTIONID,@STARTDATE,@ASOFDATE,@CURRENCYID;

                set @VALUE = coalesce(@PLEDGEBALANCE, 0) + coalesce(@TOTALRECEIVED, 0);