USP_CREDITPAYMENT_GETTRANSACTION

            CREATE procedure dbo.USP_CREDITPAYMENT_GETTRANSACTION (
                @CREDITPAYMENTID uniqueidentifier
            )
            as
            begin
                select
                    [CREDITPAYMENT].[AMOUNT],
                    [CREDITPAYMENT].[REFUNDPROCESSED],
                    [CREDITCARDPAYMENTMETHODDETAIL].[TRANSACTIONID]
                from dbo.[CREDITPAYMENT]
                left join dbo.[FINANCIALTRANSACTIONLINEITEM] on
                    [CREDITPAYMENT].[REVENUESPLITID] = [FINANCIALTRANSACTIONLINEITEM].[ID]
                inner join dbo.[FINANCIALTRANSACTION]
                    on 
                        [CREDITPAYMENT].[REVENUEID] = [FINANCIALTRANSACTION].[ID] or
                        ([FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONID] = [FINANCIALTRANSACTION].[ID] and [CREDITPAYMENT].[REVENUEID] is null)
                inner join dbo.[REVENUEPAYMENTMETHOD]
                    on [FINANCIALTRANSACTION].[ID] = [REVENUEPAYMENTMETHOD].[REVENUEID]
                inner join dbo.[CREDITCARDPAYMENTMETHODDETAIL]
                    on [REVENUEPAYMENTMETHOD].[ID] = [CREDITCARDPAYMENTMETHODDETAIL].[ID]
                where [CREDITPAYMENT].[ID] = @CREDITPAYMENTID
            end