[Home] [Help]
View: BIS_HR_BIMONTHS_V
View Text
SELECT 'HR BIMONTH'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, -13+((2*ROWNUM)-1))
, 'MON-YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, -13+((2*ROWNUM)-1))
, 'MON-YYYY') VALUE
, 'HR BIMONTH' PERIOD_SET_NAME
, TO_CHAR(ADD_MONTHS(SYSDATE
, -13+((2*ROWNUM)-1))
, 'MON-YYYY') PERIOD_NAME
, TRUNC(ADD_MONTHS(SYSDATE
, -13+((2*ROWNUM)-1))
, 'MON') START_DATE
, LAST_DAY(ADD_MONTHS(TRUNC(SYSDATE)
, -12+((2*ROWNUM)-1))) END_DATE
, TO_NUMBER(TO_CHAR(ADD_MONTHS(SYSDATE
, -13+((2*ROWNUM)-1))
, 'YYYY')) PERIOD_YEAR
, TO_CHAR(NULL) ORGANIZATION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM HR_LOOKUPS
WHERE ROWNUM < 72
Columns
Name |
ID |
VALUE |
PERIOD_SET_NAME |
PERIOD_NAME |
START_DATE |
END_DATE |
PERIOD_YEAR |
ORGANIZATION_ID |
ORGANIZATION_TYPE |