DBA Data[Home] [Help]

VIEW: APPS.BEN_ELIG_OPTD_MDCR_PRTE_D

Source

View Text - Preformatted

SELECT eom.ELIG_OPTD_MDCR_PRTE_ID ,eom.EFFECTIVE_START_DATE ,eom.EFFECTIVE_END_DATE ,eom.OPTD_MDCR_FLAG ,eom.EXLCD_FLAG ,eom.ELIGY_PRFL_ID ,eom.LAST_UPDATE_DATE ,fuser.user_name from BEN_ELIG_OPTD_MDCR_PRTE_F eom, fnd_user fuser WHERE fuser.user_id(+) = eom.last_updated_by
View Text - HTML Formatted

SELECT EOM.ELIG_OPTD_MDCR_PRTE_ID
, EOM.EFFECTIVE_START_DATE
, EOM.EFFECTIVE_END_DATE
, EOM.OPTD_MDCR_FLAG
, EOM.EXLCD_FLAG
, EOM.ELIGY_PRFL_ID
, EOM.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ELIG_OPTD_MDCR_PRTE_F EOM
, FND_USER FUSER
WHERE FUSER.USER_ID(+) = EOM.LAST_UPDATED_BY