VIEW: APPS.HRI_CL_TRAVEL_PERCENT_X_V

Source

View Text - Preformatted

SELECT hrl.lookup_code ID , hrl.meaning VALUE , hrl.description , hrl.enabled_flag , hrl.start_date_active START_DATE , hrl.end_date_active END_DATE FROM hr_lookups hrl WHERE lookup_type = 'IRC_TRAVEL_PERCENTAGE' 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 , to_char(null) DESCRIPTION , 'Y' ENABLED_FLAG , hr_general.start_of_time START_DATE , hr_general.end_of_time END_DATE FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT HRL.LOOKUP_CODE ID
, HRL.MEANING VALUE
, HRL.DESCRIPTION
, HRL.ENABLED_FLAG
, HRL.START_DATE_ACTIVE START_DATE
, HRL.END_DATE_ACTIVE END_DATE
FROM HR_LOOKUPS HRL
WHERE LOOKUP_TYPE = 'IRC_TRAVEL_PERCENTAGE'
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
, TO_CHAR(NULL) DESCRIPTION
, 'Y' ENABLED_FLAG
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
FROM DUAL WITH READ ONLY