Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_TTL_CVG_VOL_PRTE_D |
SELECT ETC.ELIG_TTL_CVG_VOL_PRTE_ID
, ETC.EFFECTIVE_START_DATE
, ETC.EFFECTIVE_END_DATE
, ETC.BUSINESS_GROUP_ID
, ETC.EXCLD_FLAG
, ETC.NO_MN_CVG_VOL_AMT_APLS_FLAG
, ETC.NO_MX_CVG_VOL_AMT_APLS_FLAG
, ETC.ELIGY_PRFL_ID
, ETC.LAST_UPDATE_DATE
, ETC.LAST_UPDATED_BY
, ETC.LAST_UPDATE_LOGIN
, ETC.CREATED_BY
, ETC.CREATION_DATE
, ETC.OBJECT_VERSION_NUMBER
, ETC.ORDR_NUM
, ETC.MN_CVG_VOL_AMT
, ETC.MX_CVG_VOL_AMT
, ETC.CVG_VOL_DET_CD
, ETC.CVG_VOL_DET_RL
FROM BEN_ELIG_TTL_CVG_VOL_PRTE_F ETC
, FND_USER_VIEW FUSER
WHERE FUSER.USER_ID(+) = ETC.LAST_UPDATED_BY