View: BEN_ENRT_PERD_FOR_PL_D

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_ENRT_PERD_FOR_PL_D

View Text

SELECT ERP.ROWID ROW_ID
, ERP.ENRT_PERD_FOR_PL_ID
, ERP.EFFECTIVE_START_DATE
, ERP.EFFECTIVE_END_DATE
, ENRT_CVG_STRT_DT.MEANING
, ENRT_CVG_STRT_DT2.FORMULA_NAME
, ENRT_CVG_END_DT.MEANING
, ENRT_CVG_END_DT2.FORMULA_NAME
, RT_STRT_DT.MEANING
, RT_STRT_DT2.FORMULA_NAME
, RT_END_DT.MEANING
, RT_END_DT2.FORMULA_NAME
, TO_CHAR(ENRT_PERD.STRT_DT
, 'DD-MON-YYYY') || ' - ' || TO_CHAR(ENRT_PERD.END_DT
, 'DD-MON-YYYY')
, PL.NAME
, ERP.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_ENRT_PERD_FOR_PL_F ERP
, FND_USER FUSER
, BEN_ENRT_PERD ENRT_PERD
, BEN_PL_F PL
, HR_LOOKUPS ENRT_CVG_STRT_DT
, HR_LOOKUPS ENRT_CVG_END_DT
, HR_LOOKUPS RT_STRT_DT
, HR_LOOKUPS RT_END_DT
, FF_FORMULAS_F ENRT_CVG_STRT_DT2
, FF_FORMULAS_F ENRT_CVG_END_DT2
, FF_FORMULAS_F RT_STRT_DT2
, FF_FORMULAS_F RT_END_DT2
WHERE FUSER.USER_ID (+)= ERP .LAST_UPDATED_BY
AND ENRT_PERD.ENRT_PERD_ID (+)= ERP .ENRT_PERD_ID
AND PL.PL_ID (+)= ERP .PL_ID
AND ENRT_CVG_STRT_DT.LOOKUP_CODE (+)= ERP .ENRT_CVG_STRT_DT_CD
AND ENRT_CVG_STRT_DT.LOOKUP_TYPE (+)= 'BEN_ENRT_CVG_STRT'
AND ENRT_CVG_END_DT.LOOKUP_CODE (+)= ERP .ENRT_CVG_END_DT_CD
AND ENRT_CVG_END_DT.LOOKUP_TYPE (+)= 'BEN_ENRT_CVG_END'
AND RT_STRT_DT.LOOKUP_CODE (+)= ERP .RT_STRT_DT_CD
AND RT_STRT_DT.LOOKUP_TYPE (+)= 'BEN_RT_STRT'
AND RT_END_DT.LOOKUP_CODE (+)= ERP .RT_END_DT_CD
AND RT_END_DT.LOOKUP_TYPE (+)= 'BEN_RT_END'
AND ENRT_CVG_STRT_DT2.FORMULA_ID (+)= ERP .ENRT_CVG_STRT_DT_RL
AND ERP .EFFECTIVE_START_DATE BETWEEN ENRT_CVG_STRT_DT2.EFFECTIVE_START_DATE(+)
AND ENRT_CVG_STRT_DT2.EFFECTIVE_END_DATE(+)
AND ENRT_CVG_END_DT2.FORMULA_ID (+)= ERP .ENRT_CVG_END_DT_RL
AND ERP .EFFECTIVE_START_DATE BETWEEN ENRT_CVG_END_DT2.EFFECTIVE_START_DATE(+)
AND ENRT_CVG_END_DT2.EFFECTIVE_END_DATE(+)
AND RT_STRT_DT2.FORMULA_ID (+)= ERP .RT_STRT_DT_RL
AND ERP .EFFECTIVE_START_DATE BETWEEN RT_STRT_DT2.EFFECTIVE_START_DATE(+)
AND RT_STRT_DT2.EFFECTIVE_END_DATE(+)
AND RT_END_DT2.FORMULA_ID (+)= ERP .RT_END_DT_RL
AND ERP .EFFECTIVE_START_DATE BETWEEN RT_END_DT2.EFFECTIVE_START_DATE(+)
AND RT_END_DT2.EFFECTIVE_END_DATE(+)

Columns