SELECT hrl.lookup_code ID , hrl.meaning VALUE , NVL(hrl.start_date_active, hr_general.start_of_time) START_DATE , NVL(hrl.end_date_active, hr_general.end_of_time) END_DATE , hrl.enabled_flag ENABLED_FLAG FROM HR_LOOKUPS hrl WHERE lookup_type = 'VACANCY_STATUS' AND TRUNC(SYSDATE) BETWEEN NVL(hrl.start_date_active, hr_general.start_of_time) AND NVL(hrl.end_date_active, hr_general.end_of_time) UNION ALL SELECT 'NA_EDW' ID ,'' VALUE ,hr_general.start_of_time START_DATE ,hr_general.end_of_time END_DATE ,'Y' ENABLED_FLAG FROM DUAL WITH READ ONLY
SELECT HRL.LOOKUP_CODE ID
, HRL.MEANING VALUE
, NVL(HRL.START_DATE_ACTIVE
, HR_GENERAL.START_OF_TIME) START_DATE
, NVL(HRL.END_DATE_ACTIVE
, HR_GENERAL.END_OF_TIME) END_DATE
, HRL.ENABLED_FLAG ENABLED_FLAG
FROM HR_LOOKUPS HRL
WHERE LOOKUP_TYPE = 'VACANCY_STATUS'
AND TRUNC(SYSDATE) BETWEEN NVL(HRL.START_DATE_ACTIVE
, HR_GENERAL.START_OF_TIME)
AND NVL(HRL.END_DATE_ACTIVE
, HR_GENERAL.END_OF_TIME) UNION ALL SELECT 'NA_EDW' ID
, '' VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, 'Y' ENABLED_FLAG
FROM DUAL WITH READ ONLY
|
|
|