Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ELIG_JOB_PRTE |
SELECT EJP.ELIG_JOB_PRTE_ID
, EJP.EFFECTIVE_START_DATE
, EJP.EFFECTIVE_END_DATE
, EJP.ORDR_NUM
, EJP.EXCLD_FLAG
, EJP.JOB_ID
, EJP.ELIGY_PRFL_ID
, EJP.BUSINESS_GROUP_ID
, EJP.EJP_ATTRIBUTE_CATEGORY
, EJP.EJP_ATTRIBUTE1
, EJP.EJP_ATTRIBUTE2
, EJP.EJP_ATTRIBUTE3
, EJP.EJP_ATTRIBUTE4
, EJP.EJP_ATTRIBUTE5
, EJP.EJP_ATTRIBUTE6
, EJP.EJP_ATTRIBUTE7
, EJP.EJP_ATTRIBUTE8
, EJP.EJP_ATTRIBUTE9
, EJP.EJP_ATTRIBUTE10
, EJP.EJP_ATTRIBUTE11
, EJP.EJP_ATTRIBUTE12
, EJP.EJP_ATTRIBUTE13
, EJP.EJP_ATTRIBUTE14
, EJP.EJP_ATTRIBUTE15
, EJP.EJP_ATTRIBUTE16
, EJP.EJP_ATTRIBUTE17
, EJP.EJP_ATTRIBUTE18
, EJP.EJP_ATTRIBUTE19
, EJP.EJP_ATTRIBUTE20
, EJP.EJP_ATTRIBUTE21
, EJP.EJP_ATTRIBUTE22
, EJP.EJP_ATTRIBUTE23
, EJP.EJP_ATTRIBUTE24
, EJP.EJP_ATTRIBUTE25
, EJP.EJP_ATTRIBUTE26
, EJP.EJP_ATTRIBUTE27
, EJP.EJP_ATTRIBUTE28
, EJP.EJP_ATTRIBUTE29
, EJP.EJP_ATTRIBUTE30
, EJP.LAST_UPDATE_DATE
, EJP.LAST_UPDATED_BY
, EJP.LAST_UPDATE_LOGIN
, EJP.CREATED_BY
, EJP.CREATION_DATE
, EJP.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_JOB_PRTE_F EJP
WHERE EJP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EJP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))