VIEW: APPS.HRICV_HR_MONTH

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_MONTH' Period_Set_Name , to_char(calc.this_date,'YYYY-MON-DD')|| ' (M'|| to_char(calc.period_no)|| ')' Period_Name /*Currently only truncs to start of month*/ , calc.this_date Start_Date , add_months(calc.this_date,1)-1 End_Date , calc.period_no Period_No_In_Year , trunc(calc.this_date,'YYYY') Period_Year , to_char(NULL) Organization_ID , to_char(NULL) Organization_TYPE FROM ( SELECT calc1.this_date this_date , months_between(calc1.this_date,trunc(calc1.this_date,'YYYY')) + 1 period_no FROM ( SELECT add_months(trunc(sysdate,'MON') /* floor todays date to first day of month*/ , (rownum-1-600)) /* add row offset and increment */ this_date FROM hr_lookups) calc1 ) calc WHERE rownum <= 1200 /* +/- 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_MONTH' PERIOD_SET_NAME
, TO_CHAR(CALC.THIS_DATE
, 'YYYY-MON-DD')|| ' (M'|| TO_CHAR(CALC.PERIOD_NO)|| ')' PERIOD_NAME /*CURRENTLY ONLY TRUNCS TO START OF MONTH*/
, CALC.THIS_DATE START_DATE
, ADD_MONTHS(CALC.THIS_DATE
, 1)-1 END_DATE
, CALC.PERIOD_NO PERIOD_NO_IN_YEAR
, TRUNC(CALC.THIS_DATE
, 'YYYY') PERIOD_YEAR
, TO_CHAR(NULL) ORGANIZATION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM ( SELECT CALC1.THIS_DATE THIS_DATE
, MONTHS_BETWEEN(CALC1.THIS_DATE
, TRUNC(CALC1.THIS_DATE
, 'YYYY')) + 1 PERIOD_NO
FROM ( SELECT ADD_MONTHS(TRUNC(SYSDATE
, 'MON') /* FLOOR TODAYS DATE TO FIRST DAY OF MONTH*/
, (ROWNUM-1-600)) /* ADD ROW OFFSET
AND INCREMENT */ THIS_DATE
FROM HR_LOOKUPS) CALC1 ) CALC
WHERE ROWNUM <= 1200 /* +/- 50 YEARS = 100 YEARS*/ WITH READ ONLY