View: HXTFV_ADD_ELEM_INFO

Product:	HXT - Time and Labor
Description:
Implementation/DBA Data:	APPS.HXTFV_ADD_ELEM_INFO

View Text

SELECT /* $HEADER: HXTVIEW.LDT 115.3 2001/08/31 15:17:25 PKM SHIP $ */ HR_GENERAL.DECODE_LOOKUP('HXT_EARNING_CATEGORY'
, EIF.EARNING_CATEGORY) EARNING_CATEGORY
, HR_GENERAL.DECODE_LOOKUP('HXT_ABSENCE_TYPE'
, EIF.ABSENCE_TYPE) ABSENCE_TYPE
, EIF.ABSENCE_POINTS ABSENCE_POINTS
, HR_GENERAL.DECODE_LOOKUP('HXT_PREMIUM_TYPE'
, EIF.PREMIUM_TYPE) PREMIUM_TYPE
, EIF.PREMIUM_AMOUNT PREMIUM_AMOUNT
, EIF.PROCESSING_ORDER PROCESSING_ORDER
, EIF.EXPENDITURE_TYPE EXPENDITURE_TYPE
, PET.ELEMENT_NAME ELEMENT_NAME
, EIF.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, '_DF:HXT:HXT_ADD_ELEM_INFO_F:EIF' /*******/ /* IDS */ /*******/
, EIF.ID ELEMENT_INFO_ID
, EIF.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
FROM HXT_ADD_ELEM_INFO_F EIF
, PAY_ELEMENT_TYPES_F PET
WHERE SYSDATE BETWEEN EIF.EFFECTIVE_START_DATE
AND EIF.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND EIF.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID WITH READ ONLY

Columns