USP_SAVE_BENEFITGLDISTRIBUTION_FINANCIALTRANSACTION

create procedure dbo.USP_SAVE_BENEFITGLDISTRIBUTION_FINANCIALTRANSACTION
(
    @FTID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CHANGEDATE datetime = null
)
as
begin
    set nocount on;

    declare @LINEITEMS UDT_GENERICID
    insert into @LINEITEMS
    select
        LI.ID
    from
        dbo.FINANCIALTRANSACTIONLINEITEM LI
        inner join dbo.REVENUEBENEFIT_EXT RBX on RBX.ID = LI.ID
    where LI.FINANCIALTRANSACTIONID = @FTID

    exec dbo.USP_SAVE_BENEFITGLDISTRIBUTION_LINEITEMS @LINEITEMS, @CHANGEAGENTID, @CHANGEDATE

end