VIEW: APPS.BEN_ELIG_CVRD_DPNT_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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