VIEW: APPS.BEN_ELIG_LOA_RSN_PRTE

Source

View Text - Preformatted

SELECT elr.ELIG_LOA_RSN_PRTE_ID ,elr.EFFECTIVE_START_DATE ,elr.EFFECTIVE_END_DATE ,elr.BUSINESS_GROUP_ID ,elr.ELIGY_PRFL_ID ,elr.ORDR_NUM ,elr.EXCLD_FLAG , ELR.CRITERIA_SCORE , ELR.CRITERIA_WEIGHT ,elr.ELR_ATTRIBUTE_CATEGORY ,elr.ELR_ATTRIBUTE1 ,elr.ELR_ATTRIBUTE2 ,elr.ELR_ATTRIBUTE3 ,elr.ELR_ATTRIBUTE4 ,elr.ELR_ATTRIBUTE5 ,elr.ELR_ATTRIBUTE6 ,elr.ELR_ATTRIBUTE7 ,elr.ELR_ATTRIBUTE8 ,elr.ELR_ATTRIBUTE9 ,elr.ELR_ATTRIBUTE10 ,elr.ELR_ATTRIBUTE11 ,elr.ELR_ATTRIBUTE12 ,elr.ELR_ATTRIBUTE13 ,elr.ELR_ATTRIBUTE14 ,elr.ELR_ATTRIBUTE15 ,elr.ELR_ATTRIBUTE16 ,elr.ELR_ATTRIBUTE17 ,elr.ELR_ATTRIBUTE18 ,elr.ELR_ATTRIBUTE19 ,elr.ELR_ATTRIBUTE20 ,elr.ELR_ATTRIBUTE21 ,elr.ELR_ATTRIBUTE22 ,elr.ELR_ATTRIBUTE23 ,elr.ELR_ATTRIBUTE24 ,elr.ELR_ATTRIBUTE25 ,elr.ELR_ATTRIBUTE26 ,elr.ELR_ATTRIBUTE27 ,elr.ELR_ATTRIBUTE28 ,elr.ELR_ATTRIBUTE29 ,elr.ELR_ATTRIBUTE30 ,elr.LAST_UPDATE_DATE ,elr.LAST_UPDATED_BY ,elr.LAST_UPDATE_LOGIN ,elr.CREATED_BY ,elr.CREATION_DATE ,elr.OBJECT_VERSION_NUMBER ,elr.ABSENCE_ATTENDANCE_TYPE_ID ,elr.ABS_ATTENDANCE_REASON_ID from BEN_ELIG_LOA_RSN_PRTE_F elr WHERE elr.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and elr.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT ELR.ELIG_LOA_RSN_PRTE_ID
, ELR.EFFECTIVE_START_DATE
, ELR.EFFECTIVE_END_DATE
, ELR.BUSINESS_GROUP_ID
, ELR.ELIGY_PRFL_ID
, ELR.ORDR_NUM
, ELR.EXCLD_FLAG
, ELR.CRITERIA_SCORE
, ELR.CRITERIA_WEIGHT
, ELR.ELR_ATTRIBUTE_CATEGORY
, ELR.ELR_ATTRIBUTE1
, ELR.ELR_ATTRIBUTE2
, ELR.ELR_ATTRIBUTE3
, ELR.ELR_ATTRIBUTE4
, ELR.ELR_ATTRIBUTE5
, ELR.ELR_ATTRIBUTE6
, ELR.ELR_ATTRIBUTE7
, ELR.ELR_ATTRIBUTE8
, ELR.ELR_ATTRIBUTE9
, ELR.ELR_ATTRIBUTE10
, ELR.ELR_ATTRIBUTE11
, ELR.ELR_ATTRIBUTE12
, ELR.ELR_ATTRIBUTE13
, ELR.ELR_ATTRIBUTE14
, ELR.ELR_ATTRIBUTE15
, ELR.ELR_ATTRIBUTE16
, ELR.ELR_ATTRIBUTE17
, ELR.ELR_ATTRIBUTE18
, ELR.ELR_ATTRIBUTE19
, ELR.ELR_ATTRIBUTE20
, ELR.ELR_ATTRIBUTE21
, ELR.ELR_ATTRIBUTE22
, ELR.ELR_ATTRIBUTE23
, ELR.ELR_ATTRIBUTE24
, ELR.ELR_ATTRIBUTE25
, ELR.ELR_ATTRIBUTE26
, ELR.ELR_ATTRIBUTE27
, ELR.ELR_ATTRIBUTE28
, ELR.ELR_ATTRIBUTE29
, ELR.ELR_ATTRIBUTE30
, ELR.LAST_UPDATE_DATE
, ELR.LAST_UPDATED_BY
, ELR.LAST_UPDATE_LOGIN
, ELR.CREATED_BY
, ELR.CREATION_DATE
, ELR.OBJECT_VERSION_NUMBER
, ELR.ABSENCE_ATTENDANCE_TYPE_ID
, ELR.ABS_ATTENDANCE_REASON_ID
FROM BEN_ELIG_LOA_RSN_PRTE_F ELR
WHERE ELR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND ELR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))