SQL> host cat tests/costs.sql
with t as
(
select 'general' as nam, 10 as costs, to_date('01.01.2018','dd.mm.yyyy') as dstart, to_date('01.01.2019','dd.mm.yyyy') as dend  from dual
union all
select 'general' as nam, 15 as costs, to_date('02.01.2019','dd.mm.yyyy') as dstart, null as dend  from dual
union all
select 'ooo roga' as nam, 12 as costs, to_date('05.01.2019','dd.mm.yyyy') as dstart, to_date('02.08.2019','dd.mm.yyyy')  as dend  from dual
union all
select 'ooo roga' as nam, 11 as costs, to_date('03.08.2019','dd.mm.yyyy') as dstart, null  as dend  from dual
union all
select 'ooo kopyta' as nam, 14 as costs, to_date('13.08.2020','dd.mm.yyyy') as dstart, null  as dend  from dual
)
select *
from t
where nam in (:cname, 'general')
and sysdate between dstart and nvl(dend,date'9999-01-01')
order by decode(nam,'general',2,1)
fetch first 1 rows only;
SQL>
SQL>
SQL> var cname varchar2(10)
SQL> exec :cname:='ooo roga';

PL/SQL procedure successfully completed.

SQL> @tests/costs.sql

NAM             COSTS DSTART              DEND
---------- ---------- ------------------- -------------------
ooo roga           11 2019-08-03 00:00:00

SQL> exec :cname:='ooo noname';

PL/SQL procedure successfully completed.

SQL> @tests/costs.sql

NAM             COSTS DSTART              DEND
---------- ---------- ------------------- -------------------
general            15 2019-01-02 00:00:00