VIEW: APPS.BEN_LEE_RSN_D

Source

View Text - Preformatted

SELECT LEN.LEE_RSN_ID , LEN.EFFECTIVE_START_DATE , LEN.EFFECTIVE_END_DATE , LEN.POPL_ENRT_TYP_CYCL_ID , LEN.LER_ID , LEN.CLS_ENRT_DT_TO_USE_CD , LEN.DYS_AFTR_END_TO_DFLT_NUM , LEN.ENRT_CVG_END_DT_CD , LEN.ENRT_CVG_STRT_DT_CD , LEN.ENRT_PERD_STRT_DT_CD , LEN.ENRT_PERD_STRT_DT_RL , LEN.ENRT_PERD_END_DT_CD , LEN.ENRT_PERD_END_DT_RL , LEN.ADDL_PROCG_DYS_NUM , LEN.DYS_NO_ENRL_NOT_ELIG_NUM , LEN.DYS_NO_ENRL_CANT_ENRL_NUM , LEN.RT_END_DT_CD , LEN.RT_END_DT_RL , LEN.RT_STRT_DT_CD , LEN.RT_STRT_DT_RL , LEN.ENRT_CVG_END_DT_RL , LEN.ENRT_CVG_STRT_DT_RL , LEN.ENRT_PERD_DET_OVRLP_BCKDT_CD , LEN.LAST_UPDATE_DATE , fuser.user_name FROM BEN_LEE_RSN_F LEN, fnd_user fuser WHERE fuser.user_id(+) = len.last_updated_by

View Text - HTML Formatted

SELECT LEN.LEE_RSN_ID
, LEN.EFFECTIVE_START_DATE
, LEN.EFFECTIVE_END_DATE
, LEN.POPL_ENRT_TYP_CYCL_ID
, LEN.LER_ID
, LEN.CLS_ENRT_DT_TO_USE_CD
, LEN.DYS_AFTR_END_TO_DFLT_NUM
, LEN.ENRT_CVG_END_DT_CD
, LEN.ENRT_CVG_STRT_DT_CD
, LEN.ENRT_PERD_STRT_DT_CD
, LEN.ENRT_PERD_STRT_DT_RL
, LEN.ENRT_PERD_END_DT_CD
, LEN.ENRT_PERD_END_DT_RL
, LEN.ADDL_PROCG_DYS_NUM
, LEN.DYS_NO_ENRL_NOT_ELIG_NUM
, LEN.DYS_NO_ENRL_CANT_ENRL_NUM
, LEN.RT_END_DT_CD
, LEN.RT_END_DT_RL
, LEN.RT_STRT_DT_CD
, LEN.RT_STRT_DT_RL
, LEN.ENRT_CVG_END_DT_RL
, LEN.ENRT_CVG_STRT_DT_RL
, LEN.ENRT_PERD_DET_OVRLP_BCKDT_CD
, LEN.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_LEE_RSN_F LEN
, FND_USER FUSER
WHERE FUSER.USER_ID(+) = LEN.LAST_UPDATED_BY