CMS_UFN_BANKINGSYSTEM_LIST

    create function dbo.CMS_UFN_BANKINGSYSTEM_LIST(@INCLUDEDISABLED bit = 0)
    returns table
    as
    return
    (
        select
            BANKINGSYSTEM.ID,
            BANKINGSYSTEM.CONDITIONSETTINGNAME,
            cast
            (
                case
                    when CONDITIONSETTING.ID is null
                        then 0
                    else
                        1
                end
                as bit
            ) as CONDITIONSETTINGENABLED,
            BANKINGSYSTEM.NAME
        from
            dbo.BANKINGSYSTEM
            left join dbo.CONDITIONSETTING on BANKINGSYSTEM.CONDITIONSETTINGNAME = CONDITIONSETTING.NAME
        where
            @INCLUDEDISABLED = 1 or CONDITIONSETTING.ID is not null
    )