View: BEN_ELIG_TO_PRTE_RSN_D

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

View Text

SELECT PEO.ROWID ROW_ID
, PEO.ELIG_TO_PRTE_RSN_ID
, PEO.EFFECTIVE_START_DATE
, PEO.EFFECTIVE_END_DATE
, LER.NAME
, OIPL_PL.NAME || '-' || OIPL_OPT.NAME
, PGM.NAME
, PL.NAME
, IGNR_PRTN_OVRID.MEANING
, ELIG_INELIG.MEANING
, PRTN_EFF_STRT_DT.MEANING
, PRTN_EFF_STRT_DT2.FORMULA_NAME
, PRTN_EFF_END_DT.MEANING
, PRTN_EFF_END_DT2.FORMULA_NAME
, WAIT_PERD_DT.MEANING
, PEO.WAIT_PERD_VAL
, WAIT_PERD.MEANING
, PEO.MX_POE_VAL
, MX_POE.MEANING
, PRTN_OVRIDBL.MEANING
, PEO.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
, PEO.VRFY_FMLY_MMBR_CD
, PEO.VRFY_FMLY_MMBR_RL
FROM BEN_ELIG_TO_PRTE_RSN_F PEO
, FND_USER FUSER
, BEN_LER_F LER
, BEN_OIPL_F OIPL
, BEN_PL_F OIPL_PL
, BEN_OPT_F OIPL_OPT
, BEN_PGM_F PGM
, BEN_PL_F PL
, HR_LOOKUPS ELIG_INELIG
, HR_LOOKUPS PRTN_EFF_STRT_DT
, HR_LOOKUPS PRTN_EFF_END_DT
, HR_LOOKUPS WAIT_PERD_DT
, HR_LOOKUPS WAIT_PERD
, HR_LOOKUPS MX_POE
, HR_LOOKUPS IGNR_PRTN_OVRID
, HR_LOOKUPS PRTN_OVRIDBL
, FF_FORMULAS_F PRTN_EFF_STRT_DT2
, FF_FORMULAS_F PRTN_EFF_END_DT2
WHERE FUSER.USER_ID (+)= PEO.LAST_UPDATED_BY
AND LER.LER_ID (+)= PEO.LER_ID
AND OIPL.OIPL_ID (+)= PEO.OIPL_ID
AND OIPL_PL.PL_ID(+) = OIPL.PL_ID
AND OIPL_OPT.OPT_ID(+) = OIPL.OPT_ID
AND PGM.PGM_ID (+)= PEO.PGM_ID
AND PL.PL_ID (+)= PEO.PL_ID
AND ELIG_INELIG.LOOKUP_CODE (+)= PEO.ELIG_INELIG_CD
AND ELIG_INELIG.LOOKUP_TYPE (+)= 'BEN_ELIG_INELIG'
AND PRTN_EFF_STRT_DT.LOOKUP_CODE (+)= PEO.PRTN_EFF_STRT_DT_CD
AND PRTN_EFF_STRT_DT.LOOKUP_TYPE (+)= 'BEN_PRTN_ELIG_STRT'
AND PRTN_EFF_END_DT.LOOKUP_CODE (+)= PEO.PRTN_EFF_END_DT_CD
AND PRTN_EFF_END_DT.LOOKUP_TYPE (+)= 'BEN_PRTN_ELIG_END'
AND WAIT_PERD_DT.LOOKUP_CODE (+)= PEO.WAIT_PERD_DT_TO_USE_CD
AND WAIT_PERD_DT.LOOKUP_TYPE (+)= 'BEN_MX_WTG_DT_TO_USE'
AND WAIT_PERD.LOOKUP_CODE (+)= PEO.WAIT_PERD_UOM
AND WAIT_PERD.LOOKUP_TYPE (+)= 'BEN_TM_UOM'
AND MX_POE.LOOKUP_CODE (+)= PEO.MX_POE_UOM
AND MX_POE.LOOKUP_TYPE (+)= 'BEN_TM_UOM'
AND IGNR_PRTN_OVRID.LOOKUP_CODE (+)= PEO.IGNR_PRTN_OVRID_FLAG
AND IGNR_PRTN_OVRID.LOOKUP_TYPE (+)= 'YES_NO'
AND PRTN_OVRIDBL.LOOKUP_CODE (+)= PEO.PRTN_OVRIDBL_FLAG
AND PRTN_OVRIDBL.LOOKUP_TYPE (+)= 'YES_NO'
AND PRTN_EFF_STRT_DT2.FORMULA_ID (+)= PEO .PRTN_EFF_STRT_DT_RL
AND PEO.EFFECTIVE_START_DATE BETWEEN PRTN_EFF_STRT_DT2.EFFECTIVE_START_DATE(+)
AND PRTN_EFF_STRT_DT2.EFFECTIVE_END_DATE(+)
AND PRTN_EFF_END_DT2.FORMULA_ID (+)= PEO .PRTN_EFF_END_DT_RL
AND PEO .EFFECTIVE_START_DATE BETWEEN PRTN_EFF_END_DT2.EFFECTIVE_START_DATE(+)
AND PRTN_EFF_END_DT2.EFFECTIVE_END_DATE(+)
AND PEO .EFFECTIVE_START_DATE BETWEEN LER.EFFECTIVE_START_DATE(+)
AND LER.EFFECTIVE_END_DATE(+)
AND OIPL .EFFECTIVE_START_DATE BETWEEN OIPL_PL.EFFECTIVE_START_DATE(+)
AND OIPL_PL.EFFECTIVE_END_DATE(+)
AND OIPL .EFFECTIVE_START_DATE BETWEEN OIPL_OPT.EFFECTIVE_START_DATE(+)
AND OIPL_OPT.EFFECTIVE_END_DATE(+)
AND PEO .EFFECTIVE_START_DATE BETWEEN PGM.EFFECTIVE_START_DATE(+)
AND PGM.EFFECTIVE_END_DATE(+)
AND PEO .EFFECTIVE_START_DATE BETWEEN PL.EFFECTIVE_START_DATE(+)
AND PL.EFFECTIVE_END_DATE(+)
AND PEO .EFFECTIVE_START_DATE BETWEEN OIPL.EFFECTIVE_START_DATE(+)
AND OIPL.EFFECTIVE_END_DATE(+)

Columns