View: BEN_PRTN_ELIG_D

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

View Text

SELECT EPA.ROWID ROW_ID
, EPA.PRTN_ELIG_ID
, EPA.EFFECTIVE_START_DATE
, EPA.EFFECTIVE_END_DATE
, PGM.NAME
, PL.NAME
, OIPL_PL.NAME || '-' || OIPL_OPT.NAME
, HR_GENERAL.DECODE_LOOKUP('BEN_PRTN_ELIG_STRT'
, EPA.PRTN_EFF_STRT_DT_CD )
, HR_GENERAL.DECODE_LOOKUP( 'BEN_PRTN_ELIG_END'
, EPA.PRTN_EFF_END_DT_CD )
, PRTN_EFF_STRT_DT_RL.FORMULA_NAME
, PRTN_EFF_END_DT_RL.FORMULA_NAME
, HR_GENERAL.DECODE_LOOKUP('BEN_MX_WTG_DT_TO_USE'
, EPA.WAIT_PERD_DT_TO_USE_CD )
, WAIT_PERD_DT_TO_USE_RL.FORMULA_NAME
, EPA.WAIT_PERD_VAL
, HR_GENERAL.DECODE_LOOKUP('BEN_TM_UOM'
, EPA.WAIT_PERD_UOM )
, WAIT_PERD_RL.FORMULA_NAME
, EPA.MX_POE_VAL
, MX_POE_RL.FORMULA_NAME
, EPA.LAST_UPDATE_DATE
, FUSER.USER_NAME
, EPA.TRK_SCR_FOR_INELG_FLAG
FROM BEN_PRTN_ELIG_F EPA
, FND_USER FUSER
, BEN_PGM_F PGM
, BEN_PL_F PL
, BEN_OIPL_F OIPL
, BEN_PL_F OIPL_PL
, BEN_OPT_F OIPL_OPT
, FF_FORMULAS_F WAIT_PERD_DT_TO_USE_RL
, FF_FORMULAS_F WAIT_PERD_RL
, FF_FORMULAS_F MX_POE_RL
, FF_FORMULAS_F PRTN_EFF_STRT_DT_RL
, FF_FORMULAS_F PRTN_EFF_END_DT_RL
WHERE FUSER.USER_ID (+) = EPA.LAST_UPDATED_BY
AND PGM.PGM_ID (+) = EPA.PGM_ID
AND EPA.EFFECTIVE_START_DATE BETWEEN PGM.EFFECTIVE_START_DATE (+)
AND PGM.EFFECTIVE_END_DATE (+)
AND PL.PL_ID (+) = EPA.PL_ID
AND OIPL.OIPL_ID (+) = EPA.OIPL_ID
AND OIPL_PL.PL_ID (+) = OIPL.PL_ID
AND OIPL_OPT.OPT_ID (+) = OIPL.OPT_ID
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 WAIT_PERD_DT_TO_USE_RL.FORMULA_ID (+) = EPA.WAIT_PERD_DT_TO_USE_RL
AND EPA.EFFECTIVE_START_DATE BETWEEN WAIT_PERD_DT_TO_USE_RL.EFFECTIVE_START_DATE (+)
AND WAIT_PERD_DT_TO_USE_RL.EFFECTIVE_END_DATE (+)
AND WAIT_PERD_RL.FORMULA_ID (+) = EPA.WAIT_PERD_RL
AND EPA.EFFECTIVE_START_DATE BETWEEN WAIT_PERD_RL.EFFECTIVE_START_DATE (+)
AND WAIT_PERD_RL.EFFECTIVE_END_DATE (+)
AND PRTN_EFF_STRT_DT_RL.FORMULA_ID (+) = EPA.PRTN_EFF_STRT_DT_RL
AND EPA.EFFECTIVE_START_DATE BETWEEN PRTN_EFF_STRT_DT_RL.EFFECTIVE_START_DATE (+)
AND PRTN_EFF_STRT_DT_RL.EFFECTIVE_END_DATE (+)
AND PRTN_EFF_END_DT_RL.FORMULA_ID (+) = EPA.PRTN_EFF_END_DT_RL
AND EPA.EFFECTIVE_START_DATE BETWEEN PRTN_EFF_END_DT_RL.EFFECTIVE_START_DATE (+)
AND PRTN_EFF_END_DT_RL.EFFECTIVE_END_DATE (+)
AND MX_POE_RL.FORMULA_ID (+) = EPA.MX_POE_RL
AND EPA.EFFECTIVE_START_DATE BETWEEN MX_POE_RL.EFFECTIVE_START_DATE (+)
AND MX_POE_RL.EFFECTIVE_END_DATE (+)

Columns