VIEW: APPS.HRICV_HR_YEAR

Source

View Text - Preformatted

SELECT /* $Header: hriovcv.odf 115.1 2001/09/12 00:47:46 pkm ship        $ */ to_char(calc.this_date,'YYYY-MM-DD') ID , calc.this_date Value , 'HR_YEAR' Period_Set_Name , to_char(calc.this_date,'YYYY-MON-DD') Period_Name , trunc(calc.this_date) Start_Date , add_months(calc.this_date,12) - 1 End_Date , 1 Period_No_In_Year , trunc(calc.this_date,'YYYY') Period_Year , to_char(NULL) Organization_ID , to_char(NULL) Organization_TYPE FROM ( SELECT add_months( trunc(sysdate,'YYYY') /*first day of the year*/ , ((rownum-1-50)*12) ) /* add row offset and increment */ this_date FROM hr_lookups) calc WHERE rownum <= 100 /*+/- 50 years = 100 years */ WITH READ ONLY

View Text - HTML Formatted

SELECT /* $HEADER: HRIOVCV.ODF 115.1 2001/09/12 00:47:46 PKM SHIP $ */ TO_CHAR(CALC.THIS_DATE
, 'YYYY-MM-DD') ID
, CALC.THIS_DATE VALUE
, 'HR_YEAR' PERIOD_SET_NAME
, TO_CHAR(CALC.THIS_DATE
, 'YYYY-MON-DD') PERIOD_NAME
, TRUNC(CALC.THIS_DATE) START_DATE
, ADD_MONTHS(CALC.THIS_DATE
, 12) - 1 END_DATE
, 1 PERIOD_NO_IN_YEAR
, TRUNC(CALC.THIS_DATE
, 'YYYY') PERIOD_YEAR
, TO_CHAR(NULL) ORGANIZATION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM ( SELECT ADD_MONTHS( TRUNC(SYSDATE
, 'YYYY') /*FIRST DAY OF THE YEAR*/
, ((ROWNUM-1-50)*12) ) /* ADD ROW OFFSET
AND INCREMENT */ THIS_DATE
FROM HR_LOOKUPS) CALC
WHERE ROWNUM <= 100 /*+/- 50 YEARS = 100 YEARS */ WITH READ ONLY