[Home] [Help]
View: HRILV_BMT_X
Product: | HRI - Human Resources Intelligence (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ HRL.LOOKUP_CODE ID
, HRL.MEANING VALUE
, NVL(HRL.START_DATE_ACTIVE
, HR_GENERAL.START_OF_TIME) DATE_FROM
, NVL(HRL.END_DATE_ACTIVE
, HR_GENERAL.END_OF_TIME) DATE_TO /*OTHER*/
, HRL.ENABLED_FLAG VALID_CODE
FROM HR_LOOKUPS HRL
WHERE HRL.LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE'
AND HRL.ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(HRL.START_DATE_ACTIVE)
, HR_GENERAL.START_OF_TIME)
AND NVL(TRUNC(HRL.END_DATE_ACTIVE)
, HR_GENERAL.END_OF_TIME) WITH READ ONLY
Columns
Name |
ID |
VALUE |
DATE_FROM |
DATE_TO |
VALID_CODE |