USP_KPI_DESIGNATION_GOALVALUE

Parameters

Parameter	Parameter Type	Mode
@VALUE	money	INOUT
@DESIGNATIONID	uniqueidentifier	IN
@DESIGNATIONGOALID	uniqueidentifier	IN
@ORGPOSITIONSSELECTIONID	uniqueidentifier	IN
@CURRENCYID	uniqueidentifier	IN

Definition

Copy



                CREATE procedure dbo.USP_KPI_DESIGNATION_GOALVALUE

                @VALUE money output,
                @DESIGNATIONID uniqueidentifier,
                @DESIGNATIONGOALID uniqueidentifier,
                @ORGPOSITIONSSELECTIONID uniqueidentifier = null,
                @CURRENCYID uniqueidentifier = null

                as

                set nocount on;

                select @VALUE = GOAL from dbo.DESIGNATIONGOAL
                where ID = @DESIGNATIONGOALID;