View: PAYLV_LOOKUP_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAYLV_LOOKUP_V

View Text

SELECT HL.APPLICATION_ID
, HL.LOOKUP_TYPE
, HL.LOOKUP_CODE
, HL.MEANING
, HL.ENABLED_FLAG
, HL.START_DATE_ACTIVE
, HL.END_DATE_ACTIVE
, HL.DESCRIPTION
, HL.LOOKUP_TYPE ORDER_BY
, HL.LAST_UPDATE_DATE
, HL.LAST_UPDATED_BY
, HL.LAST_UPDATE_LOGIN
, HL.CREATED_BY
, HL.CREATION_DATE
FROM HR_LOOKUPS HL UNION ALL SELECT -1
, NULL
, NULL
, NULL
, 'Y'
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, ' '
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL) ORDER_BY
FROM DUAL WITH READ ONLY

Columns