CREATE OR REPLACE FUNCTION XXI.get_tab_ptf (dateOtch IN Date)
 RETURN t_tf_tab PIPELINED AS
               
    BEGIN
      /* Удалить все записи
      BEGIN
         DELETE FROM table3;
       END;  
       */
     FOR i IN (
             SELECT c.ID, p.date_begin , p.date_end , round(MONTHS_BETWEEN(trunc(p.Date_End), trunc(p.Date_begin))) mm
                 from table1 c
                 join table2 p on p.Contract_Id = c.id
                 where p.date_begin <= dateOtch and (c.date_close > dateOtch or c.date_close is null)
     )
     LOOP
       /* Вставить записи...
       Insert into table3 (Id, date_degin, date_end, month) values (i.id, i.date_begin, i.date_end, i.mm)
       */
       pipe row (t_tf_row(i.id, i.date_begin,i.date_end,i.mm));
     END LOOP;
     RETURN;

    END;

CREATE OR REPLACE FUNCTION XXI.get_tab_ptf (dateOtch IN Date)
 RETURN t_tf_tab PIPELINED AS
 ret t_tf_row;      
         
    BEGIN

     FOR i IN (
             SELECT c.ID, p.date_begin , p.date_end , round(MONTHS_BETWEEN(trunc(p.Date_End), trunc(p.Date_begin))) mm
                 from table1 c
                 join table2 p on p.Contract_Id = c.id
                 where p.date_begin <= dateOtch and (c.date_close > dateOtch or c.date_close is null)
                       and c.ID = 4343
     /*Результат этого запроса
     1, 01.01.2017 , 26.03.2017, 3
     */
     )
     LOOP
     FOR q IN 0 .. i.mm
       LOOP
            /*если вывести так  pipe row*/
           pipe row (XXI.t_tf_row(i.id, i.date_begin,i.date_end, q)
           /*получаю такой результат
           1, 01.01.2017, 26.03.2017 , 1 
           1, 01.01.2017, 26.03.2017 , 2
           1, 01.01.2017, 26.03.2017 , 3
           , подскажите как сделать такой вид, через курсор как-то, добавить нужно одно поле еще последний день месяца?
           1, 01.01.2017, 26.03.2017 , 0 , 31.01.2017
           1, 01.01.2017, 26.03.2017 , 1 , 28.02.2017 
           1, 01.01.2017, 26.03.2017 , 2 , 31.03.2017
           чтобы получилось так...
         pipe row (XXI.t_tf_row(i.id, i.date_begin,i.date_end, q,/* и + последний день месяца*/ ));          
*/
       END LOOP;  
       
--       pipe row (XXI.t_tf_row(i.id, i.date_begin,i.date_end,q));
       
     END LOOP;
     RETURN;

    END;

CREATE OR REPLACE FUNCTION XXI.get_tab_ptf (dateOtch IN Date)
 RETURN t_tf_tab PIPELINED AS
   ret t_tf_row;      
   v_Id Numeric;
   v_Date_begin Date;
   v_Date_end Date;
   v_LastWorkDateMonth Date;
     
    BEGIN
    

     FOR i IN (
             SELECT c.ID, p.date_begin , p.date_end , round(MONTHS_BETWEEN(trunc(p.Date_End), trunc(p.Date_begin))) mm
                 from table1 c
                 join table2 p on p.Contract_Id = c.id
                 where p.date_begin <= dateOtch and (c.date_close > dateOtch or c.date_close is null)
                       and c.ID = 4343
     )
     LOOP
     FOR q IN 0 .. i.mm
       LOOP
          
     
           SELECT c.ID, p.date_begin , p.date_end 
                  , case when trunc(Last_Day(ADD_MONTHS(p.date_begin,q))) <= p.date_end
                                 then trunc(Last_Day(ADD_MONTHS(p.date_begin,q)))
                      else trunc(p.date_end) end
           INTO v_Id, v_Date_begin, v_Date_end, v_LastWorkDateMonth
           from table1 c
           join table2 p on p.Contract_Id = c.id
           where p.date_begin <= dateOtch and (c.date_close > dateOtch or c.date_close is null)
                 and c.ID = 4343;
           
         pipe row (XXI.t_tf_row(v_Id, v_Date_begin,v_Date_end, q, v_LastWorkDateMonth));
          

       END LOOP;  
       
--       pipe row (XXI.t_tf_row(i.id, i.date_begin,i.date_end,q));
       
     END LOOP;
     RETURN;

    END;