USP_DATAFORMTEMPLATE_VIEW_REVENUEHASTAXDEDUCTIBLEMATCHINGGIFTS

            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_REVENUEHASTAXDEDUCTIBLEMATCHINGGIFTS
            (
                @ID uniqueidentifier,
                @TAXDEDUCTIBLEMATCHINGGIFTEXISTS bit = null output,
                @DATALOADED bit = 0 output,
                @HASMATCHINGGIFTCLAIM bit = null output
            )
            as
                set nocount on;
                set @TAXDEDUCTIBLEMATCHINGGIFTEXISTS = 0;
                set @DATALOADED = 1;

                select
                @TAXDEDUCTIBLEMATCHINGGIFTEXISTS = 1
                from dbo.REVENUEMATCHINGGIFT
                left outer join dbo.MATCHINGGIFTCONDITION on MATCHINGGIFTCONDITION.ID = REVENUEMATCHINGGIFT.MATCHINGGIFTCONDITIONID
                WHERE 
                REVENUEMATCHINGGIFT.MGSOURCEREVENUEID = @ID
                AND MATCHINGGIFTCONDITION.MATCHTYPECODE = 1 -- 1 corresponds to TAX DEDUCTIBLE PORTION ONLY

                select
                @HASMATCHINGGIFTCLAIM = 1
                from dbo.REVENUEMATCHINGGIFT
                left join dbo.INSTALLMENTSPLITPAYMENT on INSTALLMENTSPLITPAYMENT.PLEDGEID = REVENUEMATCHINGGIFT.ID
                where REVENUEMATCHINGGIFT.MGSOURCEREVENUEID = @ID
                and REVENUEMATCHINGGIFT.MATCHINGGIFTCONDITIONID is not null
                and INSTALLMENTSPLITPAYMENT.ID is null;