VIEW: APPS.BEN_ELIG_TTL_PRTT_PRTE

Source

View Text - Preformatted

SELECT ETP.ROWID, ETP.ELIG_TTL_PRTT_PRTE_ID , ETP.EFFECTIVE_START_DATE , ETP.EFFECTIVE_END_DATE , ETP.BUSINESS_GROUP_ID , ETP.EXCLD_FLAG , ETP.NO_MN_PRTT_NUM_APLS_FLAG , ETP.NO_MX_PRTT_NUM_APLS_FLAG , ETP.ELIGY_PRFL_ID , ETP.ETP_ATTRIBUTE_CATEGORY , ETP.ETP_ATTRIBUTE1 , ETP.ETP_ATTRIBUTE2 , ETP.ETP_ATTRIBUTE3 , ETP.ETP_ATTRIBUTE4 , ETP.ETP_ATTRIBUTE5 , ETP.ETP_ATTRIBUTE6 , ETP.ETP_ATTRIBUTE7 , ETP.ETP_ATTRIBUTE8 , ETP.ETP_ATTRIBUTE9 , ETP.ETP_ATTRIBUTE10 , ETP.ETP_ATTRIBUTE11 , ETP.ETP_ATTRIBUTE12 , ETP.ETP_ATTRIBUTE13 , ETP.ETP_ATTRIBUTE14 , ETP.ETP_ATTRIBUTE15 , ETP.ETP_ATTRIBUTE16 , ETP.ETP_ATTRIBUTE17 , ETP.ETP_ATTRIBUTE18 , ETP.ETP_ATTRIBUTE19 , ETP.ETP_ATTRIBUTE20 , ETP.ETP_ATTRIBUTE21 , ETP.ETP_ATTRIBUTE22 , ETP.ETP_ATTRIBUTE23 , ETP.ETP_ATTRIBUTE24 , ETP.ETP_ATTRIBUTE25 , ETP.ETP_ATTRIBUTE26 , ETP.ETP_ATTRIBUTE27 , ETP.ETP_ATTRIBUTE28 , ETP.ETP_ATTRIBUTE29 , ETP.ETP_ATTRIBUTE30 , ETP.LAST_UPDATE_DATE , ETP.LAST_UPDATED_BY , ETP.LAST_UPDATE_LOGIN , ETP.CREATED_BY , ETP.CREATION_DATE , ETP.OBJECT_VERSION_NUMBER , ETP.ORDR_NUM , ETP.MN_PRTT_NUM , ETP.MX_PRTT_NUM , ETP.PRTT_DET_CD , ETP.PRTT_DET_RL FROM     BEN_ELIG_TTL_PRTT_PRTE_F ETP WHERE ETP.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and ETP.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT ETP.ROWID
, ETP.ELIG_TTL_PRTT_PRTE_ID
, ETP.EFFECTIVE_START_DATE
, ETP.EFFECTIVE_END_DATE
, ETP.BUSINESS_GROUP_ID
, ETP.EXCLD_FLAG
, ETP.NO_MN_PRTT_NUM_APLS_FLAG
, ETP.NO_MX_PRTT_NUM_APLS_FLAG
, ETP.ELIGY_PRFL_ID
, ETP.ETP_ATTRIBUTE_CATEGORY
, ETP.ETP_ATTRIBUTE1
, ETP.ETP_ATTRIBUTE2
, ETP.ETP_ATTRIBUTE3
, ETP.ETP_ATTRIBUTE4
, ETP.ETP_ATTRIBUTE5
, ETP.ETP_ATTRIBUTE6
, ETP.ETP_ATTRIBUTE7
, ETP.ETP_ATTRIBUTE8
, ETP.ETP_ATTRIBUTE9
, ETP.ETP_ATTRIBUTE10
, ETP.ETP_ATTRIBUTE11
, ETP.ETP_ATTRIBUTE12
, ETP.ETP_ATTRIBUTE13
, ETP.ETP_ATTRIBUTE14
, ETP.ETP_ATTRIBUTE15
, ETP.ETP_ATTRIBUTE16
, ETP.ETP_ATTRIBUTE17
, ETP.ETP_ATTRIBUTE18
, ETP.ETP_ATTRIBUTE19
, ETP.ETP_ATTRIBUTE20
, ETP.ETP_ATTRIBUTE21
, ETP.ETP_ATTRIBUTE22
, ETP.ETP_ATTRIBUTE23
, ETP.ETP_ATTRIBUTE24
, ETP.ETP_ATTRIBUTE25
, ETP.ETP_ATTRIBUTE26
, ETP.ETP_ATTRIBUTE27
, ETP.ETP_ATTRIBUTE28
, ETP.ETP_ATTRIBUTE29
, ETP.ETP_ATTRIBUTE30
, ETP.LAST_UPDATE_DATE
, ETP.LAST_UPDATED_BY
, ETP.LAST_UPDATE_LOGIN
, ETP.CREATED_BY
, ETP.CREATION_DATE
, ETP.OBJECT_VERSION_NUMBER
, ETP.ORDR_NUM
, ETP.MN_PRTT_NUM
, ETP.MX_PRTT_NUM
, ETP.PRTT_DET_CD
, ETP.PRTT_DET_RL
FROM BEN_ELIG_TTL_PRTT_PRTE_F ETP
WHERE ETP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND ETP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))