UFN_REFUND_HASREVERSEDORDERLEVELDISCOUNT

create function dbo.UFN_REFUND_HASREVERSEDORDERLEVELDISCOUNT
(
    @REFUNDID uniqueidentifier
)
returns bit
as begin
    return (
        select case
            when exists (
                select *
                from dbo.FINANCIALTRANSACTIONLINEITEM REFUNDDISCOUNTLINEITEM
                inner join dbo.CREDITITEM_EXT REFUNDDISCOUNTLINEITEM_EXT on REFUNDDISCOUNTLINEITEM_EXT.ID = REFUNDDISCOUNTLINEITEM.ID
                inner join dbo.SALESORDERITEMORDERDISCOUNT ORDERDISCOUNT on ORDERDISCOUNT.ID = REFUNDDISCOUNTLINEITEM_EXT.SALESORDERITEMID
                where REFUNDDISCOUNTLINEITEM.FINANCIALTRANSACTIONID = @REFUNDID
            )
            then 1
            else 0
        end
    );
end