VIEW: APPS.BEN_PRTN_ELIG_D

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)