VIEW: APPS.BEN_PRTN_ELIG

Source

View Text - Preformatted

SELECT epa.PRTN_ELIG_ID ,epa.EFFECTIVE_START_DATE ,epa.EFFECTIVE_END_DATE ,epa.BUSINESS_GROUP_ID ,epa.PGM_ID ,epa.PL_ID ,epa.OIPL_ID ,epa.PRTN_EFF_STRT_DT_CD ,epa.PRTN_EFF_END_DT_CD ,epa.PRTN_EFF_STRT_DT_RL ,epa.PRTN_EFF_END_DT_RL ,epa.WAIT_PERD_VAL ,epa.WAIT_PERD_UOM ,epa.trk_scr_for_inelg_flag ,epa.EPA_ATTRIBUTE_CATEGORY ,epa.EPA_ATTRIBUTE1 ,epa.EPA_ATTRIBUTE2 ,epa.EPA_ATTRIBUTE3 ,epa.EPA_ATTRIBUTE4 ,epa.EPA_ATTRIBUTE5 ,epa.EPA_ATTRIBUTE6 ,epa.EPA_ATTRIBUTE7 ,epa.EPA_ATTRIBUTE8 ,epa.EPA_ATTRIBUTE9 ,epa.EPA_ATTRIBUTE10 ,epa.EPA_ATTRIBUTE11 ,epa.EPA_ATTRIBUTE12 ,epa.EPA_ATTRIBUTE13 ,epa.EPA_ATTRIBUTE14 ,epa.EPA_ATTRIBUTE15 ,epa.EPA_ATTRIBUTE16 ,epa.EPA_ATTRIBUTE17 ,epa.EPA_ATTRIBUTE18 ,epa.EPA_ATTRIBUTE19 ,epa.EPA_ATTRIBUTE20 ,epa.EPA_ATTRIBUTE21 ,epa.EPA_ATTRIBUTE22 ,epa.EPA_ATTRIBUTE23 ,epa.EPA_ATTRIBUTE24 ,epa.EPA_ATTRIBUTE25 ,epa.EPA_ATTRIBUTE26 ,epa.EPA_ATTRIBUTE27 ,epa.EPA_ATTRIBUTE28 ,epa.EPA_ATTRIBUTE29 ,epa.EPA_ATTRIBUTE30 ,epa.LAST_UPDATE_DATE ,epa.LAST_UPDATED_BY ,epa.LAST_UPDATE_LOGIN ,epa.CREATED_BY ,epa.CREATION_DATE ,epa.OBJECT_VERSION_NUMBER ,epa.PTIP_ID ,epa.PLIP_ID ,epa.WAIT_PERD_DT_TO_USE_CD ,epa.WAIT_PERD_DT_TO_USE_RL ,epa.WAIT_PERD_RL ,epa.MX_POE_UOM ,epa.MX_POE_VAL ,epa.MX_POE_RL ,epa.MX_POE_APLS_CD ,epa.MX_POE_DET_DT_CD ,epa.MX_POE_DET_DT_RL from BEN_PRTN_ELIG_F epa WHERE epa.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and epa.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT EPA.PRTN_ELIG_ID
, EPA.EFFECTIVE_START_DATE
, EPA.EFFECTIVE_END_DATE
, EPA.BUSINESS_GROUP_ID
, EPA.PGM_ID
, EPA.PL_ID
, EPA.OIPL_ID
, EPA.PRTN_EFF_STRT_DT_CD
, EPA.PRTN_EFF_END_DT_CD
, EPA.PRTN_EFF_STRT_DT_RL
, EPA.PRTN_EFF_END_DT_RL
, EPA.WAIT_PERD_VAL
, EPA.WAIT_PERD_UOM
, EPA.TRK_SCR_FOR_INELG_FLAG
, EPA.EPA_ATTRIBUTE_CATEGORY
, EPA.EPA_ATTRIBUTE1
, EPA.EPA_ATTRIBUTE2
, EPA.EPA_ATTRIBUTE3
, EPA.EPA_ATTRIBUTE4
, EPA.EPA_ATTRIBUTE5
, EPA.EPA_ATTRIBUTE6
, EPA.EPA_ATTRIBUTE7
, EPA.EPA_ATTRIBUTE8
, EPA.EPA_ATTRIBUTE9
, EPA.EPA_ATTRIBUTE10
, EPA.EPA_ATTRIBUTE11
, EPA.EPA_ATTRIBUTE12
, EPA.EPA_ATTRIBUTE13
, EPA.EPA_ATTRIBUTE14
, EPA.EPA_ATTRIBUTE15
, EPA.EPA_ATTRIBUTE16
, EPA.EPA_ATTRIBUTE17
, EPA.EPA_ATTRIBUTE18
, EPA.EPA_ATTRIBUTE19
, EPA.EPA_ATTRIBUTE20
, EPA.EPA_ATTRIBUTE21
, EPA.EPA_ATTRIBUTE22
, EPA.EPA_ATTRIBUTE23
, EPA.EPA_ATTRIBUTE24
, EPA.EPA_ATTRIBUTE25
, EPA.EPA_ATTRIBUTE26
, EPA.EPA_ATTRIBUTE27
, EPA.EPA_ATTRIBUTE28
, EPA.EPA_ATTRIBUTE29
, EPA.EPA_ATTRIBUTE30
, EPA.LAST_UPDATE_DATE
, EPA.LAST_UPDATED_BY
, EPA.LAST_UPDATE_LOGIN
, EPA.CREATED_BY
, EPA.CREATION_DATE
, EPA.OBJECT_VERSION_NUMBER
, EPA.PTIP_ID
, EPA.PLIP_ID
, EPA.WAIT_PERD_DT_TO_USE_CD
, EPA.WAIT_PERD_DT_TO_USE_RL
, EPA.WAIT_PERD_RL
, EPA.MX_POE_UOM
, EPA.MX_POE_VAL
, EPA.MX_POE_RL
, EPA.MX_POE_APLS_CD
, EPA.MX_POE_DET_DT_CD
, EPA.MX_POE_DET_DT_RL
FROM BEN_PRTN_ELIG_F EPA
WHERE EPA.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EPA.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))