UFN_CREDIT_REFUND_HASMEMBERSHIPADDON

            create function dbo.UFN_CREDIT_REFUND_HASMEMBERSHIPADDON
            (
                @CREDITID uniqueidentifier
            )
            returns bit
            with execute as caller
            as begin
                if exists (
                    select [CREDITITEM_EXT].[ID]
                    from dbo.[CREDITITEM_EXT]
                    where 
                        [CREDITITEM_EXT].[CREDITID] = @CREDITID and
                        [CREDITITEM_EXT].[TYPECODE] = 16
                )
                    return 1;

                return 0;
            end