Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_QUA_IN_GR_PRTE |
SELECT EQG.ROWID
, EQG.ELIG_QUA_IN_GR_PRTE_ID
, EQG.EFFECTIVE_START_DATE
, EQG.EFFECTIVE_END_DATE
, EQG.QUAR_IN_GRADE_CD
, EQG.EXCLD_FLAG
, EQG.BUSINESS_GROUP_ID
, EQG.ELIGY_PRFL_ID
, EQG.OBJECT_VERSION_NUMBER
, EQG.ORDR_NUM
, EQG.EQG_ATTRIBUTE_CATEGORY
, EQG.EQG_ATTRIBUTE1
, EQG.EQG_ATTRIBUTE2
, EQG.EQG_ATTRIBUTE3
, EQG.EQG_ATTRIBUTE4
, EQG.EQG_ATTRIBUTE5
, EQG.EQG_ATTRIBUTE6
, EQG.EQG_ATTRIBUTE7
, EQG.EQG_ATTRIBUTE8
, EQG.EQG_ATTRIBUTE9
, EQG.EQG_ATTRIBUTE10
, EQG.EQG_ATTRIBUTE11
, EQG.EQG_ATTRIBUTE12
, EQG.EQG_ATTRIBUTE13
, EQG.EQG_ATTRIBUTE14
, EQG.EQG_ATTRIBUTE15
, EQG.EQG_ATTRIBUTE16
, EQG.EQG_ATTRIBUTE17
, EQG.EQG_ATTRIBUTE18
, EQG.EQG_ATTRIBUTE19
, EQG.EQG_ATTRIBUTE20
, EQG.EQG_ATTRIBUTE21
, EQG.EQG_ATTRIBUTE22
, EQG.EQG_ATTRIBUTE23
, EQG.EQG_ATTRIBUTE24
, EQG.EQG_ATTRIBUTE25
, EQG.EQG_ATTRIBUTE26
, EQG.EQG_ATTRIBUTE27
, EQG.EQG_ATTRIBUTE28
, EQG.EQG_ATTRIBUTE29
, EQG.EQG_ATTRIBUTE30
, EQG.LAST_UPDATE_DATE
, EQG.LAST_UPDATED_BY
, EQG.LAST_UPDATE_LOGIN
, EQG.CREATED_BY
, EQG.CREATION_DATE
FROM BEN_ELIG_QUA_IN_GR_PRTE_F EQG
WHERE EQG.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EQG.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))