Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_HLTH_CVG_PRTE_D |
SELECT EHC.ELIG_HLTH_CVG_PRTE_ID
, EHC.EFFECTIVE_START_DATE
, EHC.EFFECTIVE_END_DATE
, EHC.EXCLD_FLAG
, EHC.BUSINESS_GROUP_ID
, EHC.ELIGY_PRFL_ID
, EHC.PL_TYP_OPT_TYP_ID
, EHC.OIPL_ID
, EHC.LAST_UPDATE_DATE
, EHC.LAST_UPDATED_BY
, EHC.LAST_UPDATE_LOGIN
, EHC.CREATED_BY
, EHC.CREATION_DATE
, EHC.OBJECT_VERSION_NUMBER
, EHC.ORDR_NUM
FROM BEN_ELIG_HLTH_CVG_PRTE_F EHC
, FND_USER_VIEW FUSER
WHERE FUSER.USER_ID(+) = EHC.LAST_UPDATED_BY