UFN_CREDIT_REFUND_HASUNEARNEDREVENUE

CREATE function dbo.UFN_CREDIT_REFUND_HASUNEARNEDREVENUE
(
    @CREDITID uniqueidentifier
)
returns bit
with execute as caller
as begin
    if exists (
        select
            CREDITITEM_EXT.ID
        from
            dbo.FINANCIALTRANSACTIONLINEITEM
        inner join
            dbo.CREDITITEM_EXT on CREDITITEM_EXT.ID = FINANCIALTRANSACTIONLINEITEM.ID
        where
            FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @CREDITID
            and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null
            and CREDITITEM_EXT.TYPECODE = 255 /*Unearned Revenue*/
    )
        return 1;

    return 0;
end