VIEW: APPS.BEN_ELIG_DSBLTY_CTG_PRTE

Source

View Text - Preformatted

SELECT elig_dsblty_ctg_prte_id ,EFFECTIVE_START_DATE ,EFFECTIVE_END_DATE ,BUSINESS_GROUP_ID ,eligy_prfl_id ,excld_flag ,CATEGORY ,ECT.CRITERIA_SCORE, ECT.CRITERIA_WEIGHT,ECT_ATTRIBUTE_CATEGORY ,ECT_ATTRIBUTE1 ,ECT_ATTRIBUTE2 ,ECT_ATTRIBUTE3 ,ECT_ATTRIBUTE4 ,ECT_ATTRIBUTE5 ,ECT_ATTRIBUTE6 ,ECT_ATTRIBUTE7 ,ECT_ATTRIBUTE8 ,ECT_ATTRIBUTE9 ,ECT_ATTRIBUTE10 ,ECT_ATTRIBUTE11 ,ECT_ATTRIBUTE12 ,ECT_ATTRIBUTE13 ,ECT_ATTRIBUTE14 ,ECT_ATTRIBUTE15 ,ECT_ATTRIBUTE16 ,ECT_ATTRIBUTE17 ,ECT_ATTRIBUTE18 ,ECT_ATTRIBUTE19 ,ECT_ATTRIBUTE20 ,ECT_ATTRIBUTE21 ,ECT_ATTRIBUTE22 ,ECT_ATTRIBUTE23 ,ECT_ATTRIBUTE24 ,ECT_ATTRIBUTE25 ,ECT_ATTRIBUTE26 ,ECT_ATTRIBUTE27 ,ECT_ATTRIBUTE28 ,ECT_ATTRIBUTE29 ,ECT_ATTRIBUTE30 ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_LOGIN ,CREATED_BY ,CREATION_DATE ,OBJECT_VERSION_NUMBER from ben_elig_dsblty_ctg_prte_f ECT WHERE ECT.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND ECT.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT ELIG_DSBLTY_CTG_PRTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ELIGY_PRFL_ID
, EXCLD_FLAG
, CATEGORY
, ECT.CRITERIA_SCORE
, ECT.CRITERIA_WEIGHT
, ECT_ATTRIBUTE_CATEGORY
, ECT_ATTRIBUTE1
, ECT_ATTRIBUTE2
, ECT_ATTRIBUTE3
, ECT_ATTRIBUTE4
, ECT_ATTRIBUTE5
, ECT_ATTRIBUTE6
, ECT_ATTRIBUTE7
, ECT_ATTRIBUTE8
, ECT_ATTRIBUTE9
, ECT_ATTRIBUTE10
, ECT_ATTRIBUTE11
, ECT_ATTRIBUTE12
, ECT_ATTRIBUTE13
, ECT_ATTRIBUTE14
, ECT_ATTRIBUTE15
, ECT_ATTRIBUTE16
, ECT_ATTRIBUTE17
, ECT_ATTRIBUTE18
, ECT_ATTRIBUTE19
, ECT_ATTRIBUTE20
, ECT_ATTRIBUTE21
, ECT_ATTRIBUTE22
, ECT_ATTRIBUTE23
, ECT_ATTRIBUTE24
, ECT_ATTRIBUTE25
, ECT_ATTRIBUTE26
, ECT_ATTRIBUTE27
, ECT_ATTRIBUTE28
, ECT_ATTRIBUTE29
, ECT_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN_ELIG_DSBLTY_CTG_PRTE_F ECT
WHERE ECT.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND ECT.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))