VIEW: APPS.BEN_ELIG_DPNT_CVRD_PLIP_D

Source

View Text - Preformatted

SELECT edi.ELIG_DPNT_CVRD_PLIP_ID ,edi.EFFECTIVE_START_DATE ,edi.EFFECTIVE_END_DATE ,edi.EXCLD_FLAG ,edi.ORDR_NUM ,edi.ENRL_DET_DT_CD ,edi.PLIP_ID ,edi.ELIGY_PRFL_ID ,edi.LAST_UPDATE_DATE ,fuser.user_name from BEN_ELIG_DPNT_CVRD_PLIP_F edi, fnd_user fuser WHERE fuser.user_id(+) = edi.last_updated_by

View Text - HTML Formatted

SELECT EDI.ELIG_DPNT_CVRD_PLIP_ID
, EDI.EFFECTIVE_START_DATE
, EDI.EFFECTIVE_END_DATE
, EDI.EXCLD_FLAG
, EDI.ORDR_NUM
, EDI.ENRL_DET_DT_CD
, EDI.PLIP_ID
, EDI.ELIGY_PRFL_ID
, EDI.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ELIG_DPNT_CVRD_PLIP_F EDI
, FND_USER FUSER
WHERE FUSER.USER_ID(+) = EDI.LAST_UPDATED_BY