USP_MEMBERSHIPINSTALLMENTPLAN_ADDORIGINALAMOUNT

            create procedure dbo.USP_MEMBERSHIPINSTALLMENTPLAN_ADDORIGINALAMOUNT(
                @REVENUEID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )as
                set nocount on

                --If there is no revenueid then exit

                if (@REVENUEID is null)
                    return 0;

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                if @CHANGEDATE is null
                    set @CHANGEDATE = getdate()                    

                if exists(select top 1 [ID] from dbo.[FINANCIALTRANSACTION] where [ID] = @REVENUEID and [TYPECODE] = 15) and
                    not exists(select top 1 [ID] from dbo.[MEMBERSHIPINSTALLMENTPLANORIGINALAMOUNT] where ID = @REVENUEID) 
                begin

                    insert into dbo.[MEMBERSHIPINSTALLMENTPLANORIGINALAMOUNT](
                        [ID],
                        [ORIGINALAMOUNT],
                        [TRANSACTIONAMOUNT],
                        [ORGANIZATIONAMOUNT],
                        [BASECURRENCYID],
                        [TRANSACTIONCURRENCYID],
                        [BASEEXCHANGERATEID],
                        [ORGANIZATIONEXCHANGERATEID],
                        [ADDEDBYID],
                        [CHANGEDBYID], 
                        [DATEADDED], 
                        [DATECHANGED]
                    )
                    select
                        FINANCIALTRANSACTION.ID,
                        FINANCIALTRANSACTION.BASEAMOUNT,
                        FINANCIALTRANSACTION.TRANSACTIONAMOUNT,
                        FINANCIALTRANSACTION.ORGAMOUNT,
                        isnull(REVENUE_EXT.NONPOSTABLEBASECURRENCYID, CURRENCYSET.BASECURRENCYID),
                        FINANCIALTRANSACTION.TRANSACTIONCURRENCYID,
                        FINANCIALTRANSACTION.BASEEXCHANGERATEID,
                        FINANCIALTRANSACTION.ORGEXCHANGERATEID,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CHANGEDATE,
                        @CHANGEDATE
                    from
                        dbo.FINANCIALTRANSACTION
                        inner join REVENUE_EXT on REVENUE_EXT.ID = FINANCIALTRANSACTION.ID
                        inner join dbo.PDACCOUNTSYSTEM on FINANCIALTRANSACTION.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
                        inner join dbo.CURRENCYSET on PDACCOUNTSYSTEM.CURRENCYSETID = CURRENCYSET.ID
                    where
                        FINANCIALTRANSACTION.ID = @REVENUEID;

                end    
                else
                    return 0;