View: BIL_DIMV_EMP_STATUS

Product:	BIL - Sales Intelligence
Description:	Employee statuses view
Implementation/DBA Data:	APPS.BIL_DIMV_EMP_STATUS

View Text

SELECT LOOKUP_CODE
, MEANING
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, DESCRIPTION
, LOOKUP_CODE
, MEANING
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'EMP_CAT' UNION ALL (SELECT FL.LOOKUP_CODE EMPLOYMENT_STATUS_PK
, FL.MEANING EMPLOYMENT_STATUS
, FL.ENABLED_FLAG ENABLED_FLAG
, FL.START_DATE_ACTIVE START_DATE_ACTIVE
, FL.END_DATE_ACTIVE END_DATE_ACTIVE
, FL.DESCRIPTION DESCRIPTION
, FL.LOOKUP_CODE ID
, FL.MEANING VALUE
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY

Columns