VIEW: APPS.BEN_ELIG_TO_PRTE_RSN_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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