UFN_APPEALBENEFIT_CONVERTAMOUNTSINXML

Fills in multicurrency fields in the given appeal benefits XML.
Return

Return Type
xml
Parameters

Parameter	Parameter Type	Mode	Description
@BENEFITDETAILS	xml	IN
Definition

Copy


            CREATE function dbo.UFN_APPEALBENEFIT_CONVERTAMOUNTSINXML(
                @BENEFITDETAILS xml
            )
            returns xml
            as
            begin

                    declare @CURRENCYEXCHANGERATEID uniqueidentifier;
                    declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();
                    declare @CURRENTDATE datetime = getdate();

                return (
                    select 
                        ID,
                        BENEFITID,
                        VALUE,
                        BASECURRENCYID,
                        VALUEPERCENT,
                        SEQUENCE,
                        QUANTITY,
                        case
                            when BASECURRENCYID <> @ORGANIZATIONCURRENCYID
                                then dbo.UFN_CURRENCY_CONVERT(VALUE, (dbo.UFN_CURRENCYEXCHANGERATE_GETLATEST(BASECURRENCYID, @ORGANIZATIONCURRENCYID, @CURRENTDATE, 0, null)))
                            else VALUE
                        end 
                        ORGANIZATIONVALUE,
                        (dbo.UFN_CURRENCYEXCHANGERATE_GETLATEST(BASECURRENCYID, @ORGANIZATIONCURRENCYID, @CURRENTDATE, 0, null)) as ORGANIZATIONEXCHANGERATEID
                    from dbo.UFN_APPEALBENEFIT_GETBENEFITDETAILS_3_FROMITEMLISTXML(@BENEFITDETAILS)
                    for xml raw('ITEM'),type,elements,root('BENEFITDETAILS'),BINARY BASE64
                )
            end