[Home] [Help]
View: HRI_CL_POSITION_HX_V
View Text
SELECT POS.POSITION_ID ID
, POS.NAME VALUE
, POS.DATE_EFFECTIVE DATE_FROM
, NVL(POS.DATE_END
, HR_GENERAL.END_OF_TIME) DATE_TO
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, POS.ORGANIZATION_ID ORGANIZATION_ID
, POS.JOB_ID JOB_ID
, POS.POSITION_DEFINITION_ID POSITION_DEFINITION_ID
FROM PER_POSITIONS POS
WHERE TRUNC(SYSDATE) <= NVL(POS.DATE_END
, HR_GENERAL.END_OF_TIME) UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME DATE_FROM
, HR_GENERAL.END_OF_TIME DATE_TO
, -1 BUSINESS_GROUP_ID
, -1 ORGANIZATION_ID
, -1 JOB_ID
, -1 POSITION_DEFINITION_ID
FROM DUAL WITH READ ONLY
Columns
Name |
ID |
VALUE |
DATE_FROM |
DATE_TO |
BUSINESS_GROUP_ID |
ORGANIZATION_ID |
JOB_ID |
POSITION_DEFINITION_ID |