VIEW: APPS.HXTFV_ADD_ELEM_INFO

Source

View Text - Preformatted

SELECT /* $Header: hxtbis.odf 120.1 2005/09/26 12:49:58 jdupont noship $ */ 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

View Text - HTML Formatted

SELECT /* $HEADER: HXTBIS.ODF 120.1 2005/09/26 12:49:58 JDUPONT NOSHIP $ */ 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