View: HRICV_HR_BIMONTH

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	APPS.HRICV_HR_BIMONTH

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_BIMONTH' PERIOD_SET_NAME
, TO_CHAR(CALC.THIS_DATE
, 'YYYY-MON-DD')|| ' (BM'|| TO_CHAR(CALC.PERIOD_NO)|| ')' PERIOD_NAME
, CALC.THIS_DATE START_DATE
, ADD_MONTHS(CALC.THIS_DATE
, 2)-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
, (MONTHS_BETWEEN(CALC1.THIS_DATE
, TRUNC(CALC1.THIS_DATE
, 'YYYY'))) / 2 + 1 PERIOD_NO
FROM ( SELECT ADD_MONTHS( /*FIRST DAY OF THE YEAR*/ TRUNC(SYSDATE
, 'YYYY') /* ROUNDED TO CURRENT BIMONTH NO. */
, FLOOR((TO_NUMBER(TO_CHAR(SYSDATE
, 'MM'))-1)/2)*2 /* PLUS ROW OFFSET
AND INCREMENT */ + ((ROWNUM-1-300)*2) ) THIS_DATE
FROM HR_LOOKUPS) CALC1 ) CALC
WHERE ROWNUM <= 600 /*+/- 50 YEARS = 100 YEARS*/ WITH READ ONLY

Columns