UFN_REVENUEBATCH_GETADDITIONALAPPLICATIONS

            CREATE function dbo.UFN_REVENUEBATCH_GETADDITIONALAPPLICATIONS(@BATCHREVENUEID uniqueidentifier)
            returns table
            as
            return
            (
                select
                   ID,
                   TYPECODE,
                   APPLIED,
                   DESIGNATIONID, 
                   OTHERTYPECODEID,
                   DECLINESGIFTAID,
                   OPPORTUNITYID,
                   SPONSORSHIPID,
                   ISGIFTAIDSPONSORSHIP,
                   GLREVENUECATEGORYMAPPINGID as CATEGORYCODEID,
                   cast(1 as bit) as DIDCAMPAIGNSDEFAULT,
                   (select
                        ID,
                        CAMPAIGNID,
                        CAMPAIGNSUBPRIORITYID,
                        REVENUESPLITCAMPAIGNID
                    from dbo.BATCHREVENUEADDITIONALAPPLICATIONCAMPAIGN
                    where BATCHREVENUEADDITIONALAPPLICATIONCAMPAIGN.BATCHREVENUEADDITIONALAPPLICATIONSID = BATCHREVENUEADDITIONALAPPLICATIONS.ID
                    for xml raw('ITEM'),type,elements,BINARY BASE64) as CAMPAIGNS, REVENUESPLITID
                from dbo.BATCHREVENUEADDITIONALAPPLICATIONS where BATCHREVENUEID = @BATCHREVENUEID
        )