View: PA_REP_YEAR_CAL_V

Product:	PA - Projects
Description:	PA_REP_YEAR_CAL_V is a view to get Calendar year numbers
Implementation/DBA Data:	APPS.PA_REP_YEAR_CAL_V

View Text

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

Columns