USP_KPI_DESIGNATIONLEVEL_GOALVALUE

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_KPI_DESIGNATIONLEVEL_GOALVALUE

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

                set nocount on;

                select @VALUE = GOAL from dbo.DESIGNATIONLEVELGOAL
                where ID = @DESIGNATIONLEVELGOALID;