USP_SIMPLEDATALIST_BANKINGSYSTEMUNIVERSALNAME

                create procedure dbo.USP_SIMPLEDATALIST_BANKINGSYSTEMUNIVERSALNAME
                as
                    set nocount on;

                    select
                        BANKINGSYSTEM.ID as VALUE,
                        BANKINGSYSTEM.NAME as LABEL
                    from
                        dbo.BANKINGSYSTEM
                        left join dbo.CONDITIONSETTING on BANKINGSYSTEM.CONDITIONSETTINGNAME = CONDITIONSETTING.NAME
                    where
                        CONDITIONSETTING.ID is not null;