UFN_REVENUEBATCH_GETADDITIONALAPPLICATIONCAMPAIGNS

Returns campaigns for a revenue batch additional application.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHREVENUEADDITIONALAPPLICATIONSID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_REVENUEBATCH_GETADDITIONALAPPLICATIONCAMPAIGNS(@BATCHREVENUEADDITIONALAPPLICATIONSID uniqueidentifier)
            returns table
            as return
                select 
                    ID, CAMPAIGNID, CAMPAIGNSUBPRIORITYID, REVENUESPLITCAMPAIGNID
                from
                    dbo.BATCHREVENUEADDITIONALAPPLICATIONCAMPAIGN
                where
                    BATCHREVENUEADDITIONALAPPLICATIONSID = @BATCHREVENUEADDITIONALAPPLICATIONSID;