VIEW: APPS.BEN_ELIG_SUPPL_ROLE_PRTE

Source

View Text - Preformatted

SELECT elig_suppl_role_prte_id ,effective_START_DATE ,effective_END_DATE ,BUSINESS_GROUP_ID ,eligy_prfl_id ,excld_flag ,job_id,job_group_id , EST.CRITERIA_SCORE , EST.CRITERIA_WEIGHT,EST_attribute_CATEGORY ,EST_ATTRIBUTE1 ,EST_ATTRIBUTE2 ,EST_ATTRIBUTE3 ,EST_ATTRIBUTE4 ,EST_ATTRIBUTE5 ,EST_ATTRIBUTE6 ,EST_ATTRIBUTE7 ,EST_ATTRIBUTE8 ,EST_ATTRIBUTE9 ,EST_ATTRIBUTE10 ,EST_ATTRIBUTE11 ,EST_ATTRIBUTE12 ,EST_ATTRIBUTE13 ,EST_ATTRIBUTE14 ,EST_ATTRIBUTE15 ,EST_ATTRIBUTE16 ,EST_ATTRIBUTE17 ,EST_ATTRIBUTE18 ,EST_ATTRIBUTE19 ,EST_ATTRIBUTE20 ,EST_ATTRIBUTE21 ,EST_ATTRIBUTE22 ,EST_ATTRIBUTE23 ,EST_ATTRIBUTE24 ,EST_ATTRIBUTE25 ,EST_ATTRIBUTE26 ,EST_ATTRIBUTE27 ,EST_ATTRIBUTE28 ,EST_ATTRIBUTE29 ,EST_ATTRIBUTE30 ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_LOGIN ,CREATED_BY ,CREATION_DATE ,OBJECT_VERSION_NUMBER from ben_elig_suppl_role_prte_f EST WHERE EST.effective_START_DATE <= (SELECT SS.effective_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND EST.effective_END_DATE >= (SELECT SS.effective_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT ELIG_SUPPL_ROLE_PRTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ELIGY_PRFL_ID
, EXCLD_FLAG
, JOB_ID
, JOB_GROUP_ID
, EST.CRITERIA_SCORE
, EST.CRITERIA_WEIGHT
, EST_ATTRIBUTE_CATEGORY
, EST_ATTRIBUTE1
, EST_ATTRIBUTE2
, EST_ATTRIBUTE3
, EST_ATTRIBUTE4
, EST_ATTRIBUTE5
, EST_ATTRIBUTE6
, EST_ATTRIBUTE7
, EST_ATTRIBUTE8
, EST_ATTRIBUTE9
, EST_ATTRIBUTE10
, EST_ATTRIBUTE11
, EST_ATTRIBUTE12
, EST_ATTRIBUTE13
, EST_ATTRIBUTE14
, EST_ATTRIBUTE15
, EST_ATTRIBUTE16
, EST_ATTRIBUTE17
, EST_ATTRIBUTE18
, EST_ATTRIBUTE19
, EST_ATTRIBUTE20
, EST_ATTRIBUTE21
, EST_ATTRIBUTE22
, EST_ATTRIBUTE23
, EST_ATTRIBUTE24
, EST_ATTRIBUTE25
, EST_ATTRIBUTE26
, EST_ATTRIBUTE27
, EST_ATTRIBUTE28
, EST_ATTRIBUTE29
, EST_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN_ELIG_SUPPL_ROLE_PRTE_F EST
WHERE EST.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EST.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))