ID     PERIOD     Amount
1         1            15
2         31          12
3         91          10 
4         181        8 

declare 
       v_period number:=26;
begin    
    with qq as
    (
      select 1 as period, 15 Amount from dual
      union all
      select 31 as period, 12 Amount from dual
      union all
      select 91 as period, 10 Amount from dual
      union all
      select 181 as period, 8 Amount from dual
    )
    select period
           , LEAD (period,1) over (ORDER BY period) AS next_period 
           , Amount 
    from qq
    where v_period between period and LEAD (period,1) over (ORDER BY period) AS next_period;
end;

SELECT id, PERIOD, next_period , AMOUNT 
FROM (
  SELECT id
         , PERIOD
         , LEAD (period,1) over (ORDER BY period) AS next_period
         , AMOUNT 
  FROM tbl_TempAmoun
) 
WHERE '31' between PERIOD and nvl(next_period,99999999)-1

 with qq as
    (
      select 1 as period, 15 Amount from dual
      union all
      select 31 as period, 12 Amount from dual
      union all
      select 91 as period, 10 Amount from dual
      union all
      select 181 as period, 8 Amount from dual
    )

SELECT p.Id
       ,(
          SELECT Amount
          FROM(
            select tfsc.PERIOD
                   , LEAD (tfsc.PERIOD,1) over (ORDER BY tfsc.PERIOD) AS next_period
                   , tfsc.Amount
            from tariff tarif
                  join tariff_s tfsc on tfsc.tariff_id = tarif.Id+1 and tfsc.cell_type_id = 148 --cell.type_id /*invalid identifier*/
            where tarif.Id = 260-- p.tarif_id /*invalid identifier*/
          )
          WHERE p.period between PERIOD and nvl(next_period,99999999)-1 
       ) Amount
FROM contract c
   JOIN prol p on p.Contract_Id = c.id
   JOIN cell cell on p.cell_id = cell.id
where c.Id = 6315

SELECT 
    ( SELECT 
             Amount
      FROM
            table(cast(multiset(select tfsc.PERIOD
                   , LEAD (tfsc.PERIOD,1) over (ORDER BY tfsc.PERIOD) AS next_period
                   , tfsc.Amount
            from tariff tarif
            join tariff_scale tfsc on tfsc.tariff_id = tarif.Id+1 and tfsc.cell_type_id = cell.type_id /*148*/ --cell.type_id /*invalid identifier*/
            where tarif.Id = p.tariff_id --260-- p.tarif_id /*invalid identifier*/
          ) as sys.odcivarchar2list ))z
          WHERE p.period between PERIOD and nvl(next_period,99999999)-1 
     ) as Amount
FROM contract c
   JOIN contract_prolongation p on p.Contract_Id = c.id
   JOIN cell cell on p.cell_id = cell.id
where c.Id = 6315 

Ранее пару постов назад делал функцию в итоге получилаю результат
Счет       Остаток  Клиент             Сумма  РангГруппы
123456      123      Иванов И.И.     1         6 
123456      123      Иванов И.И.     2         6
123456      123      Иванов И.И.     3         7
123456      123      Иванов И.И.     3         7
123456      123      Иванов И.И.     4         8
123456      123      Иванов И.И.     5         9
123456      123      Иванов И.И.     3         9
123456      123      Иванов И.И.     1         9

select  t.Account, t.Ost, t.FioClient, sum(v_sum) Ssum, rankgroup
from table(get_tab_ptf('01.01.2017')) t
where  t.Day > '01.01.2017' and
        t.NomDog = 9
Group by t."Account", t.Ost, t.NomDog, rankgroup

123456      123      Иванов И.И.     3         6 
123456      123      Иванов И.И.     6         7
123456      123      Иванов И.И.     4         8
123456      123      Иванов И.И.     9         9

счет         Остаток  Клиент           col1   col2   col3   col4   col5   col6    col7    col8    col9    col10         
123456      123      Иванов И.И.                                            3       6        4        9