UFN_REVENUE_HASGIFTAIDSPLITONPENDINGR68

Returns whether a revenue transaction has splits a pending R68 process.
Return

Return Type
bit
Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN
@ISPAYMENT	tinyint	IN
Definition

Copy


            CREATE function dbo.UFN_REVENUE_HASGIFTAIDSPLITONPENDINGR68
            (
                @REVENUEID uniqueidentifier,
                -- Passing in ISPAYMENT even though it could be calculated using 

                -- @REVENUEID since the calling code has already retrieved its value

                @ISPAYMENT tinyint
            )
            returns bit
            with 
            execute as caller
            as 
            begin
                declare @REVENUEHASGIFTAIDSPLITONPENDINGR68PROCESS bit
                set @REVENUEHASGIFTAIDSPLITONPENDINGR68PROCESS = 0

                -- Only payments have their splits submitted on the R68 report

                if @ISPAYMENT = 1
                begin
                    if exists (    select 1 from dbo.REVENUESPLITGIFTAID
                                inner join dbo.FINANCIALTRANSACTIONLINEITEM on REVENUESPLITGIFTAID.ID = FINANCIALTRANSACTIONLINEITEM.ID
                                inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
                                where
                                    FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @REVENUEID and
                                    REVENUESPLITGIFTAID.PENDINGR68STATUSID is not null and
                                    FINANCIALTRANSACTIONLINEITEM.DELETEDON is null and
                                    FINANCIALTRANSACTIONLINEITEM.TYPECODE <> 1)
                        set @REVENUEHASGIFTAIDSPLITONPENDINGR68PROCESS = 1
                end

                return @REVENUEHASGIFTAIDSPLITONPENDINGR68PROCESS
            end