FND Design Data [Home] [Help]

View: BEN_ELIG_CVRD_DPNT_D

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

SELECT PDP.ROWID
, PDP.ELIG_CVRD_DPNT_ID
, PDP.EFFECTIVE_START_DATE
, PDP.EFFECTIVE_END_DATE
, PDP.CVG_STRT_DT
, PDP.CVG_THRU_DT
, PDP.CVG_PNDG_FLAG
, PDP.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ELIG_CVRD_DPNT_F PDP
, FND_USER_VIEW FUSER
WHERE FUSER.USER_ID (+)= PDP.LAST_UPDATED_BY

Columns

Name
ROW_ID
ELIG_CVRD_DPNT_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
CVG_STRT_DT
CVG_THRU_DT
CVG_PNDG_FLAG
LAST_UPDATE_DATE
LAST_UPDATED_BY