UFN_PDACCOUNT_GETACCOUNTSYSTEMID

        create function dbo.UFN_PDACCOUNT_GETACCOUNTSYSTEMID
        (
        @REVENUESPLITID as uniqueidentifier
        )
        returns uniqueidentifier

        as begin
        declare @RESULT as uniqueidentifier


        select @RESULT=PDACCOUNTSYSTEMID from dbo.PDACCOUNTSYSTEMFORREVENUE T1 inner join REVENUESPLIT T2 On T1.ID = T2.REVENUEID where T2.ID = @REVENUESPLITID

        return @RESULT
        end