Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_PPL_GRP_PRTE |
SELECT EPG.ELIG_PPL_GRP_PRTE_ID
, EPG.EFFECTIVE_START_DATE
, EPG.EFFECTIVE_END_DATE
, EPG.EXCLD_FLAG
, EPG.ORDR_NUM
, EPG.ELIGY_PRFL_ID
, EPG.PEOPLE_GROUP_ID
, EPG.BUSINESS_GROUP_ID
, EPG.EPG_ATTRIBUTE_CATEGORY
, EPG.EPG_ATTRIBUTE1
, EPG.EPG_ATTRIBUTE2
, EPG.EPG_ATTRIBUTE3
, EPG.EPG_ATTRIBUTE4
, EPG.EPG_ATTRIBUTE5
, EPG.EPG_ATTRIBUTE6
, EPG.EPG_ATTRIBUTE7
, EPG.EPG_ATTRIBUTE8
, EPG.EPG_ATTRIBUTE9
, EPG.EPG_ATTRIBUTE10
, EPG.EPG_ATTRIBUTE11
, EPG.EPG_ATTRIBUTE12
, EPG.EPG_ATTRIBUTE13
, EPG.EPG_ATTRIBUTE14
, EPG.EPG_ATTRIBUTE15
, EPG.EPG_ATTRIBUTE16
, EPG.EPG_ATTRIBUTE17
, EPG.EPG_ATTRIBUTE18
, EPG.EPG_ATTRIBUTE19
, EPG.EPG_ATTRIBUTE20
, EPG.EPG_ATTRIBUTE21
, EPG.EPG_ATTRIBUTE22
, EPG.EPG_ATTRIBUTE23
, EPG.EPG_ATTRIBUTE24
, EPG.EPG_ATTRIBUTE25
, EPG.EPG_ATTRIBUTE26
, EPG.EPG_ATTRIBUTE27
, EPG.EPG_ATTRIBUTE28
, EPG.EPG_ATTRIBUTE29
, EPG.EPG_ATTRIBUTE30
, EPG.LAST_UPDATE_DATE
, EPG.LAST_UPDATED_BY
, EPG.LAST_UPDATE_LOGIN
, EPG.CREATED_BY
, EPG.CREATION_DATE
, EPG.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_PPL_GRP_PRTE_F EPG
WHERE EPG.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EPG.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))