Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ELIG_CMBN_AGE_LOS_PRTE |
SELECT ECP.ELIG_CMBN_AGE_LOS_PRTE_ID
, ECP.EFFECTIVE_START_DATE
, ECP.EFFECTIVE_END_DATE
, ECP.BUSINESS_GROUP_ID
, ECP.CMBN_AGE_LOS_FCTR_ID
, ECP.ELIGY_PRFL_ID
, ECP.EXCLD_FLAG
, ECP.ORDR_NUM
, ECP.MNDTRY_FLAG
, ECP.ECP_ATTRIBUTE_CATEGORY
, ECP.ECP_ATTRIBUTE1
, ECP.ECP_ATTRIBUTE2
, ECP.ECP_ATTRIBUTE3
, ECP.ECP_ATTRIBUTE4
, ECP.ECP_ATTRIBUTE5
, ECP.ECP_ATTRIBUTE6
, ECP.ECP_ATTRIBUTE7
, ECP.ECP_ATTRIBUTE8
, ECP.ECP_ATTRIBUTE9
, ECP.ECP_ATTRIBUTE10
, ECP.ECP_ATTRIBUTE11
, ECP.ECP_ATTRIBUTE12
, ECP.ECP_ATTRIBUTE13
, ECP.ECP_ATTRIBUTE14
, ECP.ECP_ATTRIBUTE15
, ECP.ECP_ATTRIBUTE16
, ECP.ECP_ATTRIBUTE17
, ECP.ECP_ATTRIBUTE18
, ECP.ECP_ATTRIBUTE19
, ECP.ECP_ATTRIBUTE20
, ECP.ECP_ATTRIBUTE21
, ECP.ECP_ATTRIBUTE22
, ECP.ECP_ATTRIBUTE23
, ECP.ECP_ATTRIBUTE24
, ECP.ECP_ATTRIBUTE25
, ECP.ECP_ATTRIBUTE26
, ECP.ECP_ATTRIBUTE27
, ECP.ECP_ATTRIBUTE28
, ECP.ECP_ATTRIBUTE29
, ECP.ECP_ATTRIBUTE30
, ECP.LAST_UPDATE_DATE
, ECP.LAST_UPDATED_BY
, ECP.LAST_UPDATE_LOGIN
, ECP.CREATED_BY
, ECP.CREATION_DATE
, ECP.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_CMBN_AGE_LOS_PRTE_F ECP
WHERE ECP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND ECP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))