UFN_REVENUESPLITGIFTAID_HASPENDINGADJUSTMENT

            create function dbo.UFN_REVENUESPLITGIFTAID_HASPENDINGADJUSTMENT
            (
                @ID uniqueidentifier
            )
            returns bit
            with execute as caller
            as 
            begin
                if exists(
                    select 
                        1 
                    from 
                        dbo.GIFTAIDGLDISTRIBUTION
                        inner join dbo.GLTRANSACTION on GIFTAIDGLDISTRIBUTION.GLTRANSACTIONID = GLTRANSACTION.REVERSEDGLTRANSACTIONID
                    where
                        GIFTAIDGLDISTRIBUTION.REVENUESPLITGIFTAIDID = @ID
                        and GLTRANSACTION.POSTSTATUSCODE = 1
                )
                    return 1;


                return 0;
            end