SELECT TO_CHAR(YR.START_DATE , 'YYYY')||'1' ID , '1 , '||TO_CHAR(YR.START_DATE , 'YYYY') VALUE , YR.START_DATE START_DATE , ADD_MONTHS(YR.START_DATE , 2)-1 END_DATE FROM FII_TIME_YEAR YR UNION ALL SELECT TO_CHAR(YR.START_DATE , 'YYYY')||'2' ID , '2 , '||TO_CHAR(YR.START_DATE , 'YYYY') VALUE , ADD_MONTHS(YR.START_DATE , 2) START_DATE , ADD_MONTHS(YR.START_DATE , 4)-1 END_DATE FROM FII_TIME_YEAR YR UNION ALL SELECT TO_CHAR(YR.START_DATE , 'YYYY')||'3' ID , '3 , '||TO_CHAR(YR.START_DATE , 'YYYY') VALUE , ADD_MONTHS(YR.START_DATE , 4) START_DATE , ADD_MONTHS(YR.START_DATE , 6)-1 END_DATE FROM FII_TIME_YEAR YR UNION ALL SELECT TO_CHAR(YR.START_DATE , 'YYYY')||'4' ID , '4 , '||TO_CHAR(YR.START_DATE , 'YYYY') VALUE , ADD_MONTHS(YR.START_DATE , 6) START_DATE , ADD_MONTHS(YR.START_DATE , 8)-1 END_DATE FROM FII_TIME_YEAR YR UNION ALL SELECT TO_CHAR(YR.START_DATE , 'YYYY')||'5' ID , '5 , '||TO_CHAR(YR.START_DATE , 'YYYY') VALUE , ADD_MONTHS(YR.START_DATE , 8) START_DATE , ADD_MONTHS(YR.START_DATE , 10)-1 END_DATE FROM FII_TIME_YEAR YR UNION ALL SELECT TO_CHAR(YR.START_DATE , 'YYYY')||'6' ID , '6 , '||TO_CHAR(YR.START_DATE , 'YYYY') VALUE , ADD_MONTHS(YR.START_DATE , 10) START_DATE , ADD_MONTHS(YR.START_DATE , 12)-1 END_DATE FROM FII_TIME_YEAR YR WITH READ ONLY