VIEW: APPS.PA_REP_YEAR_CAL_V

Source

View Text - Preformatted

SELECT to_number(to_char(add_months(sysdate,seq_number*12),'YYYY')) PERIOD_YEAR from pa_rep_seq_number WHERE seq_number between -5 and 5 order by 1

View Text - HTML Formatted

SELECT TO_NUMBER(TO_CHAR(ADD_MONTHS(SYSDATE
, SEQ_NUMBER*12)
, 'YYYY')) PERIOD_YEAR
FROM PA_REP_SEQ_NUMBER
WHERE SEQ_NUMBER BETWEEN -5
AND 5 ORDER BY 1