Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_HLTH_CVG_PRTE |
SELECT EHC.ROWID
, EHC.ELIG_HLTH_CVG_PRTE_ID
, EHC.EFFECTIVE_START_DATE
, EHC.EFFECTIVE_END_DATE
, EHC.EXCLD_FLAG
, EHC.BUSINESS_GROUP_ID
, EHC.ELIGY_PRFL_ID
, EHC.PL_TYP_OPT_TYP_ID
, EHC.OIPL_ID
, EHC.EHC_ATTRIBUTE_CATEGORY
, EHC.EHC_ATTRIBUTE1
, EHC.EHC_ATTRIBUTE2
, EHC.EHC_ATTRIBUTE3
, EHC.EHC_ATTRIBUTE4
, EHC.EHC_ATTRIBUTE5
, EHC.EHC_ATTRIBUTE6
, EHC.EHC_ATTRIBUTE7
, EHC.EHC_ATTRIBUTE8
, EHC.EHC_ATTRIBUTE9
, EHC.EHC_ATTRIBUTE10
, EHC.EHC_ATTRIBUTE11
, EHC.EHC_ATTRIBUTE12
, EHC.EHC_ATTRIBUTE13
, EHC.EHC_ATTRIBUTE14
, EHC.EHC_ATTRIBUTE15
, EHC.EHC_ATTRIBUTE16
, EHC.EHC_ATTRIBUTE17
, EHC.EHC_ATTRIBUTE18
, EHC.EHC_ATTRIBUTE19
, EHC.EHC_ATTRIBUTE20
, EHC.EHC_ATTRIBUTE21
, EHC.EHC_ATTRIBUTE22
, EHC.EHC_ATTRIBUTE23
, EHC.EHC_ATTRIBUTE24
, EHC.EHC_ATTRIBUTE25
, EHC.EHC_ATTRIBUTE26
, EHC.EHC_ATTRIBUTE27
, EHC.EHC_ATTRIBUTE28
, EHC.EHC_ATTRIBUTE29
, EHC.EHC_ATTRIBUTE30
, EHC.LAST_UPDATE_DATE
, EHC.LAST_UPDATED_BY
, EHC.LAST_UPDATE_LOGIN
, EHC.CREATED_BY
, EHC.CREATION_DATE
, EHC.OBJECT_VERSION_NUMBER
, EHC.ORDR_NUM
FROM BEN_ELIG_HLTH_CVG_PRTE_F EHC
WHERE EHC.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EHC.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))