UFN_RECOGNITIONCREDIT_DONORCHALLENGE_CONVERTAMOUNTSINXML

CREATE function dbo.UFN_RECOGNITIONCREDIT_DONORCHALLENGE_CONVERTAMOUNTSINXML
(
  @RECOGNITIONS xml,
  @BASECURRENCYID uniqueidentifier,
  @ORGANIZATIONEXCHANGERATEID uniqueidentifier
)
returns xml
as
begin
  declare @CONVERTEDLIST xml
  set @CONVERTEDLIST = dbo.UFN_REVENUERECOGNITION_CONVERTAMOUNTSINXML(@RECOGNITIONS, @BASECURRENCYID, @ORGANIZATIONEXCHANGERATEID) 

  return (
    select 
      ITEMLISTCONVERTED.ID,
      ITEMLISTCONVERTED.CONSTITUENTID,
      ITEMLISTCONVERTED.AMOUNT,
      ITEMLISTCONVERTED.EFFECTIVEDATE,
      ITEMLISTCONVERTED.REVENUERECOGNITIONTYPECODEID, 
      ITEMLISTCONVERTED.RECOGNITIONTYPE,
      ITEMLISTCONVERTED.GROSSAMOUNT,
      ITEMLISTCONVERTED.BASECURRENCYID,
      ITEMLISTCONVERTED.ORGANIZATIONAMOUNT,
      ITEMLISTCONVERTED.ORGANIZATIONEXCHANGERATEID,      
      DCRECOGNITIONS.DONOR,
      DCRECOGNITIONS.RECOGNITIONCREDITFKID,
      DCRECOGNITIONS.DESIGNATIONID,
      DCRECOGNITIONS.DESIGNATION,
      DCRECOGNITIONS.DONORCHALLENGERECOGNITIONTYPECODE
    from (
      select 
        T.c.value('(ID)[1]','uniqueidentifier') as ID,
        T.c.value('(CONSTITUENTID)[1]','uniqueidentifier') as CONSTITUENTID,
        T.c.value('(NAME)[1]','nvarchar(154)') as CONSTITUENT,
        T.c.value('(AMOUNT)[1]','money') as AMOUNT,
        T.c.value('(EFFECTIVEDATE)[1]','datetime') as EFFECTIVEDATE,
        T.c.value('(REVENUERECOGNITIONTYPECODEID)[1]','uniqueidentifier') as REVENUERECOGNITIONTYPECODEID,
        T.c.value('(RECOGNITIONTYPE)[1]','nvarchar(100)') as RECOGNITIONTYPE,
        T.c.value('(GROSSAMOUNT)[1]','money') as GROSSAMOUNT,
        T.c.value('(BASECURRENCYID)[1]','uniqueidentifier') BASECURRENCYID,
        T.c.value('(ORGANIZATIONAMOUNT)[1]','money') ORGANIZATIONAMOUNT,
        T.c.value('(ORGANIZATIONEXCHANGERATEID)[1]','uniqueidentifier') ORGANIZATIONEXCHANGERATEID

      from @CONVERTEDLIST.nodes('/RECOGNITIONS/ITEM') T(c)
    ) ITEMLISTCONVERTED
    inner join dbo.UFN_RECOGNITIONCREDIT_DONORCHALLENGE_GETRECOGNITIONS_FROMITEMLISTXML(@RECOGNITIONS) DCRECOGNITIONS 
      on (ITEMLISTCONVERTED.ID = DCRECOGNITIONS.ID)
    for xml raw('ITEM'),type,elements,root('RECOGNITIONS'),BINARY BASE64
  )

end