FND Design Data [Home] [Help]

View: BEN_ELIG_ANTHR_PL_PRTE_D

Product: BEN - Advanced Benefits
Description:
Implementation/DBA Data: ViewAPPS.BEN_ELIG_ANTHR_PL_PRTE_D
View Text

SELECT EOP.ELIG_ANTHR_PL_PRTE_ID
, EOP.PL_ID
, EOP.EFFECTIVE_START_DATE
, EOP.EFFECTIVE_END_DATE
, EOP.EXCLD_FLAG
, EOP.ELIGY_PRFL_ID
, EOP.BUSINESS_GROUP_ID
, EOP.LAST_UPDATE_DATE
, EOP.LAST_UPDATED_BY
, EOP.LAST_UPDATE_LOGIN
, EOP.CREATED_BY
, EOP.CREATION_DATE
, EOP.OBJECT_VERSION_NUMBER
, EOP.ORDR_NUM
FROM BEN_ELIG_ANTHR_PL_PRTE_F EOP
, FND_USER_VIEW FUSER
WHERE FUSER.USER_ID(+) = EOP.LAST_UPDATED_BY

Columns

Name
ELIG_ANTHR_PL_PRTE_ID
PL_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
EXCLD_FLAG
ELIGY_PRFL_ID
BUSINESS_GROUP_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
ORDR_NUM