UFN_OPPORTUNITYAMOUNTBRACKET_GETBRACKETS_2

Returns all opportunity brackets for a given opportunity bracket group.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@OPPORTUNITYBRACKETGROUPID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_OPPORTUNITYAMOUNTBRACKET_GETBRACKETS_2
(
  @OPPORTUNITYBRACKETGROUPID uniqueidentifier
)
returns table
as
return
  select
    ID,
    NAME,
    LOWERLIMIT,
    BASECURRENCYID,
    ORGANIZATIONLOWERLIMIT,
    ORGANIZATIONEXCHANGERATEID
  from
    dbo.OPPORTUNITYAMOUNTBRACKET
  where
    OPPORTUNITYBRACKETGROUPID = @OPPORTUNITYBRACKETGROUPID