VIEW: APPS.HXT_ADD_ELEM_INFO

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 ,EXCLUDE_FROM_EXPLOSION FROM HXT_ADD_ELEM_INFO_F WHERE EFFECTIVE_START_DATE <= (SELECT EFFECTIVE_DATE FROM FND_SESSIONS FNDS WHERE FNDS.SESSION_ID = USERENV('SESSIONID')) AND EFFECTIVE_END_DATE >= (SELECT EFFECTIVE_DATE FROM FND_SESSIONS FNDS WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))

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
, EXCLUDE_FROM_EXPLOSION
FROM HXT_ADD_ELEM_INFO_F
WHERE EFFECTIVE_START_DATE <= (SELECT EFFECTIVE_DATE
FROM FND_SESSIONS FNDS
WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))
AND EFFECTIVE_END_DATE >= (SELECT EFFECTIVE_DATE
FROM FND_SESSIONS FNDS
WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))