VIEW: APPS.HRI_CL_WAC_GAINTYP_X_V

Source

View Text - Preformatted

SELECT 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 , hrl.enabled_flag valid_code FROM hr_lookups hrl WHERE hrl.lookup_type = 'HRI_GAIN_TYPES' AND hrl.lookup_code like 'GAIN%' AND hrl.lookup_code <> 'GAINS' 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) UNION ALL SELECT 'NA_EDW' ID , '' VALUE , hr_general.start_of_time date_from , hr_general.end_of_time date_to , 'Y' valid_code FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT 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
, HRL.ENABLED_FLAG VALID_CODE
FROM HR_LOOKUPS HRL
WHERE HRL.LOOKUP_TYPE = 'HRI_GAIN_TYPES'
AND HRL.LOOKUP_CODE LIKE 'GAIN%'
AND HRL.LOOKUP_CODE <> 'GAINS'
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) UNION ALL SELECT 'NA_EDW' ID
, '' VALUE
, HR_GENERAL.START_OF_TIME DATE_FROM
, HR_GENERAL.END_OF_TIME DATE_TO
, 'Y' VALID_CODE
FROM DUAL WITH READ ONLY