select <...>
from
(select ...) intervalo_duomenys,
(select ...) amount_by_reception_time
where amount_by_reception_time.reception_time(+) between intervalo_duomenys.nuo and intervalo_duomenys.iki 

 select
        intervalo_duomenys.header_interval_nr,
        intervalo_duomenys.day_nr,
        intervalo_duomenys.header_interval_from,
        intervalo_duomenys.header_interval_to,
        intervalo_duomenys.interval_nr,
        intervalo_duomenys.interval_from,
        intervalo_duomenys.interval_to,
        intervalo_duomenys.reception_time,
        intervalo_duomenys.nuo,
        intervalo_duomenys.iki,
           amount_by_reception_time.reception_time as tikras_laikas,
        case
          when intervalo_duomenys.header_interval_nr = 1 and
               intervalo_duomenys.interval_nr = 1 then/*
            sepa_inst_monitoring_utl.get_pac_balance(
              p_par_id => 30,
              p_reception_date => intervalo_duomenys.reception_time,
              p_liq_control_type1 => 'F',
              p_liq_control_type2 => 'T',
              p_liq_control_type3 => 'N')*/
              2222
          else
            --round(avg(pah.amount),2)
            amount_by_reception_time.amount
        end amount
      from(
      select --intervalo_duomenys begin
        tmp4.* ,
        tmp4.reception_time - /*l_interval_length*/10/2/24/60 nuo,
        tmp4.reception_time + /*l_interval_length*/10/2/24/60 - 1/24/60/60  iki     
      from(
        select--tmp4 begin
          tmp3.*,
          case
            when tmp3.interval_nr/(/*l_interval_segments*/12/2) <= 1 then
              1
            else
              2
          end day_indicator,
          case
            when tmp3.interval_nr/(/*l_interval_segments*/12/2) <= 1 then
              to_date(to_char(decode(tmp3.day_nr,1,/*l_cur_date*/trunc(sysdate)-1,/*l_cur_date*/trunc(sysdate)),'yyyy-mm-dd') || ' ' ||
                lpad(to_char(round((tmp3.header_interval_from + tmp3.header_interval_to)/120)) - 1,2,'0') || ':' ||
                lpad(to_char(floor((tmp3.interval_from + tmp3.interval_to)/2)),2,'0') || ':00','yyyy-mm-dd hh24:mi:ss')
            else
              to_date(to_char(decode(tmp3.day_nr,1,/*l_cur_date*/trunc(sysdate)-1,/*l_cur_date*/trunc(sysdate)),'yyyy-mm-dd') || ' ' ||
                lpad(to_char(round((tmp3.header_interval_from + tmp3.header_interval_to)/120)),2,'0') || ':' ||
                lpad(to_char(floor((tmp3.interval_from + tmp3.interval_to)/2)),2,'0') || ':00','yyyy-mm-dd hh24:mi:ss')
          end reception_time
        from(
          select
            tmp2.header_interval_nr,
            case
              when tmp2.header_interval_nr <= 12 then
                1
              else
                2
            end day_nr,
            tmp2.header_interval_from,
            tmp2.header_interval_to,
            case
              when tmp2.interval_from >= 60 then
                tmp2.interval_from - 60
              else
                tmp2.interval_from
            end interval_from,
            case
              when tmp2.interval_to > 60 then
                tmp2.interval_to - 60
              else
                tmp2.interval_to
            end interval_to,
            tmp2.interval_nr
          from(
            select
              tmp1.header_interval_nr,
              case
                when tmp1.header_interval_from >= 1440 then
                  tmp1.header_interval_from - 1440
                else
                  tmp1.header_interval_from
              end header_interval_from,
              case
                when tmp1.header_interval_to > 1440 then
                  tmp1.header_interval_to - 1440
                else
                  tmp1.header_interval_to
              end header_interval_to,
              (tmp1.interval_nr - 1) * /*l_interval_length*/10 interval_from,
              (tmp1.interval_nr) * /*l_interval_length*/10 interval_to,
              tmp1.interval_nr
            from(
              select
                tmp.*,
                rank() over (partition by tmp.header_interval_nr order by tmp.dummy_level) interval_nr
              from(
                select
                  ceil(level//*l_interval_segments*/12 ) header_interval_nr,
                  (ceil(level//*l_interval_segments*/12) - 1)*60*2 header_interval_from,
                  ceil(level//*l_interval_segments*/12)*60*2 header_interval_to,
                  level dummy_level
                from
                  dual
                connect by level <= 24*/*l_interval_segments*/12) tmp) tmp1) tmp2) tmp3) tmp4  ) intervalo_duomenys,

        (select--begin amount_by_reception_time
          max(pah.balance) amount,
          pah.reception_time
        from
          sepa_pab_history pah
        where
          /*p_par_id*/30 is not null and
          pah.par_id = /*p_par_id*/30 and
          trunc(pah.reception_time) in (
            /*l_cur_date*/trunc(sysdate) - 1,
            /*l_cur_date*/trunc(sysdate))
        group by
          pah.reception_time,
          pah.par_id
      ) amount_by_reception_time
      where      
        amount_by_reception_time.reception_time(+) between intervalo_duomenys.nuo and intervalo_duomenys.iki
      order by
        intervalo_duomenys.header_interval_nr,
        intervalo_duomenys.interval_nr

 Plan Hash Value  : 

-----------------------------------------------------------------------------------------------
| Id | Operation                           | Name                | Rows | Bytes | Cost | Time |
-----------------------------------------------------------------------------------------------
|  0 | SELECT STATEMENT                    |                     |    5 |   370 |  244 |      |
|  1 |   SORT ORDER BY                     |                     |    5 |   370 |  244 |      |
|  2 |    NESTED LOOPS OUTER               |                     |    5 |   370 |  243 |      |
|  3 |     VIEW                            |                     |    1 |    52 |    3 |      |
|  4 |      WINDOW SORT                    |                     |    1 |    52 |    3 |      |
|  5 |       VIEW                          |                     |    1 |    52 |    2 |      |
|  6 |        CONNECT BY WITHOUT FILTERING |                     |      |       |      |      |
|  7 |         FAST DUAL                   |                     |    1 |       |    2 |      |
|  8 |     VIEW                            |                     |    5 |   110 |  240 |      |
|  9 |      SORT GROUP BY                  |                     | 2176 | 32640 |  240 |      |
| 10 |       TABLE ACCESS FULL             | SEPA_PAB_HISTORY_RT | 2212 | 33180 |  239 |      |
-----------------------------------------------------------------------------------------------