VIEW: APPS.HXT_ADD_ELEM_INFO_X

Source

View Text - Preformatted

SELECT id ,effective_start_date ,effective_end_date ,element_type_id ,earning_category ,absence_type ,absence_points ,premium_type ,premium_amount ,processing_order ,expenditure_type ,created_by ,creation_date ,last_update_date ,last_update_login ,last_updated_by ,attribute_category ,attribute1 ,attribute2 ,attribute3 ,attribute4 ,attribute5 ,attribute6 ,attribute7 ,attribute8 ,attribute9 ,attribute10 ,attribute11 ,attribute12 ,attribute13 ,attribute14 ,attribute15 ,attribute16 ,attribute17 ,attribute18 ,attribute19 ,attribute20 ,attribute21 ,attribute22 ,attribute23 ,attribute24 ,attribute25 ,attribute26 ,attribute27 ,attribute28 ,attribute29 ,attribute30 FROM HXT_ADD_ELEM_INFO_F WHERE EFFECTIVE_START_DATE <= TRUNC(SYSDATE) AND EFFECTIVE_END_DATE >= TRUNC(SYSDATE)

View Text - HTML Formatted

SELECT ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, ELEMENT_TYPE_ID
, EARNING_CATEGORY
, ABSENCE_TYPE
, ABSENCE_POINTS
, PREMIUM_TYPE
, PREMIUM_AMOUNT
, PROCESSING_ORDER
, EXPENDITURE_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
FROM HXT_ADD_ELEM_INFO_F
WHERE EFFECTIVE_START_DATE <= TRUNC(SYSDATE)
AND EFFECTIVE_END_DATE >= TRUNC(SYSDATE)