Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ELIG_TO_PRTE_RSN |
SELECT PEO.ELIG_TO_PRTE_RSN_ID
, PEO.EFFECTIVE_START_DATE
, PEO.EFFECTIVE_END_DATE
, PEO.BUSINESS_GROUP_ID
, PEO.LER_ID
, PEO.OIPL_ID
, PEO.PGM_ID
, PEO.PL_ID
, PEO.IGNR_PRTN_OVRID_FLAG
, PEO.ELIG_INELIG_CD
, PEO.PRTN_OVRIDBL_FLAG
, PEO.PEO_ATTRIBUTE_CATEGORY
, PEO.PEO_ATTRIBUTE1
, PEO.PEO_ATTRIBUTE2
, PEO.PEO_ATTRIBUTE3
, PEO.PEO_ATTRIBUTE4
, PEO.PEO_ATTRIBUTE5
, PEO.PEO_ATTRIBUTE6
, PEO.PEO_ATTRIBUTE7
, PEO.PEO_ATTRIBUTE8
, PEO.PEO_ATTRIBUTE9
, PEO.PEO_ATTRIBUTE10
, PEO.PEO_ATTRIBUTE11
, PEO.PEO_ATTRIBUTE12
, PEO.PEO_ATTRIBUTE13
, PEO.PEO_ATTRIBUTE14
, PEO.PEO_ATTRIBUTE15
, PEO.PEO_ATTRIBUTE16
, PEO.PEO_ATTRIBUTE17
, PEO.PEO_ATTRIBUTE18
, PEO.PEO_ATTRIBUTE19
, PEO.PEO_ATTRIBUTE20
, PEO.PEO_ATTRIBUTE21
, PEO.PEO_ATTRIBUTE22
, PEO.PEO_ATTRIBUTE23
, PEO.PEO_ATTRIBUTE24
, PEO.PEO_ATTRIBUTE25
, PEO.PEO_ATTRIBUTE26
, PEO.PEO_ATTRIBUTE27
, PEO.PEO_ATTRIBUTE28
, PEO.PEO_ATTRIBUTE29
, PEO.PEO_ATTRIBUTE30
, PEO.LAST_UPDATE_DATE
, PEO.LAST_UPDATED_BY
, PEO.LAST_UPDATE_LOGIN
, PEO.CREATED_BY
, PEO.CREATION_DATE
, PEO.OBJECT_VERSION_NUMBER
, PEO.PRTN_EFF_STRT_DT_CD
, PEO.PRTN_EFF_STRT_DT_RL
, PEO.PRTN_EFF_END_DT_CD
, PEO.PRTN_EFF_END_DT_RL
, PEO.WAIT_PERD_VAL
, PEO.WAIT_PERD_UOM
, PEO.PTIP_ID
, PEO.PLIP_ID
, PEO.WAIT_PERD_DT_TO_USE_CD
, PEO.WAIT_PERD_DT_TO_USE_RL
, PEO.WAIT_PERD_RL
, PEO.MX_POE_UOM
, PEO.MX_POE_VAL
, PEO.MX_POE_RL
, PEO.MX_POE_APLS_CD
, PEO.MX_POE_DET_DT_CD
, PEO.MX_POE_DET_DT_RL
, PEO.VRFY_FMLY_MMBR_CD
, PEO.VRFY_FMLY_MMBR_RL
FROM BEN_ELIG_TO_PRTE_RSN_F PEO
WHERE PEO.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PEO.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))