USP_SIMPLEDATALIST_MAJORGIVING_OPPORTUNITYAMOUNTRANGES

List of amount ranges for opportunities.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_MAJORGIVING_OPPORTUNITYAMOUNTRANGES
        (
        @CURRENTAPPUSERID uniqueidentifier = null       
        )
                as
                    set nocount on;

                    select ID as VALUE, NAME as LABEL from dbo.UFN_OPPORTUNITYAMOUNTRANGES_BYGROUPANDUSER(@CURRENTAPPUSERID) order by LOWERLIMIT;