UFN_BATCHREVENUEADDITIONALAPPLICATIONBUSINESSUNIT_GETBUSINESSUNITS

Returns business units for a revenue batch additional application.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHREVENUEADDITIONALAPPLICATIONID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_BATCHREVENUEADDITIONALAPPLICATIONBUSINESSUNIT_GETBUSINESSUNITS(@BATCHREVENUEADDITIONALAPPLICATIONID uniqueidentifier)
returns table
as return
            select
                ID,
        BUSINESSUNITCODEID,
        AMOUNT,
        REVENUESPLITBUSINESSUNITID
            from
                dbo.BATCHREVENUEADDITIONALAPPLICATIONBUSINESSUNIT
            where
                BATCHREVENUEADDITIONALAPPLICATIONID = @BATCHREVENUEADDITIONALAPPLICATIONID;