[Home] [Help]
View: HRICV_HR_MONTH
Product: | HRI - Human Resources Intelligence (Obsolete) |
Description: | |
Implementation/DBA Data: |
APPS.HRICV_HR_MONTH
|
View Text
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 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
Columns
Name |
ID |
VALUE |
PERIOD_SET_NAME |
PERIOD_NAME |
START_DATE |
END_DATE |
PERIOD_NO_IN_YEAR |
PERIOD_YEAR |
ORGANIZATION_ID |
ORGANIZATION_TYPE |