UFN_APPEALBENEFIT_GETBENEFITDETAILS_3

Returns all benefit details for a given appeal benefit level in multicurrency.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@APPEALBENEFITID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_APPEALBENEFIT_GETBENEFITDETAILS_3(@APPEALBENEFITID uniqueidentifier)
            returns table
            as
            return
            (
                select 
                    APPEALBENEFITDETAIL.ID,     
                    APPEALBENEFITDETAIL.BENEFITID,      
                    APPEALBENEFITDETAIL.QUANTITY, 
                    APPEALBENEFITDETAIL.VALUE, 
                    APPEALBENEFITDETAIL.VALUEPERCENT, 
                    APPEALBENEFITDETAIL.SEQUENCE, 
                    APPEALBENEFITDETAIL.ORGANIZATIONVALUE,
                    APPEALBENEFITDETAIL.BASECURRENCYID,
                    APPEALBENEFITDETAIL.ORGANIZATIONEXCHANGERATEID,
                    BENEFIT.USEPERCENT
                from dbo.APPEALBENEFITDETAIL   
                left join dbo.BENEFIT 
                    on APPEALBENEFITDETAIL.BENEFITID = BENEFIT.ID
                where APPEALBENEFITDETAIL.APPEALBENEFITID = @APPEALBENEFITID
            )