View: HRI_CL_PRF_RTNG_X_V

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	APPS.HRI_CL_PRF_RTNG_X_V

View Text

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 = 'PERFORMANCE_RATING'
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

Columns