select T.TARIFF_ID into res
    from CC_AUTO_TARIFF TL
    join BM_TARIFF T on (T.TARIFF_ID = TL.TARIFF_ID)
    where upper(TL.CODE) = upper(code)
    and T.DATE_WORK_BEG <= sysdate
    and (T.DATE_WORK_END is null or T.DATE_WORK_END > sysdate);

    select T.TARIFF_ID
    from CC_AUTO_TARIFF TL
    join BM_TARIFF T on (T.TARIFF_ID = TL.TARIFF_ID)
    where upper(TL.CODE) = upper(:code)
    and T.DATE_WORK_BEG <= sysdate
    and (T.DATE_WORK_END is null or T.DATE_WORK_END > sysdate);