View: BEN_BNFT_PRVDR_POOL_D

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

View Text

SELECT DISTINCT BPP.ROWID ROW_ID
, BPP.BNFT_PRVDR_POOL_ID
, BPP.EFFECTIVE_START_DATE
, BPP.EFFECTIVE_END_DATE
, BPP.NAME
, PGM_POOL.MEANING
, EXCS_ALWYS_FFTD.MEANING
, USE_FOR_PGM_POOL.MEANING
, PCT_RNDG.MEANING
, VAL_RNDG.MEANING
, PL.NAME
, PL_TYP.NAME
, DFLT_EXCS_TRTMT.MEANING
, DFLT_EXCS_TRTMT2.FORMULA_NAME
, RLOVR_RSTRCN.MEANING
, NO_MN_DSTRBL_PCT.MEANING
, NO_MN_DSTRBL_VAL.MEANING
, NO_MX_DSTRBL_PCT.MEANING
, NO_MX_DSTRBL_VAL.MEANING
, BPP.MN_DSTRBL_PCT_NUM
, BPP.MN_DSTRBL_VAL
, BPP.MX_DSTRBL_PCT_NUM
, BPP.MX_DSTRBL_VAL
, EXCS_TRTMT.MEANING
, AUTO_ALCT_EXCS.MEANING
, PGM.NAME
, PCT_RNDG2.FORMULA_NAME
, VAL_RNDG2.FORMULA_NAME
, OPT.NAME
, BPP.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_BNFT_PRVDR_POOL_F BPP
, FND_USER_VIEW FUSER
, BEN_PLIP_F PLIP
, BEN_PTIP_F PTIP
, BEN_PGM_F PGM
, BEN_OIPLIP_F OIPLIP
, BEN_OIPL_F OIPL
, BEN_PL_F PL
, BEN_PL_TYP_F PL_TYP
, BEN_OPT_F OPT
, HR_LOOKUPS PCT_RNDG
, HR_LOOKUPS VAL_RNDG
, HR_LOOKUPS DFLT_EXCS_TRTMT
, HR_LOOKUPS RLOVR_RSTRCN
, HR_LOOKUPS EXCS_TRTMT
, HR_LOOKUPS PGM_POOL
, HR_LOOKUPS EXCS_ALWYS_FFTD
, HR_LOOKUPS USE_FOR_PGM_POOL
, HR_LOOKUPS NO_MN_DSTRBL_PCT
, HR_LOOKUPS NO_MN_DSTRBL_VAL
, HR_LOOKUPS NO_MX_DSTRBL_PCT
, HR_LOOKUPS NO_MX_DSTRBL_VAL
, HR_LOOKUPS AUTO_ALCT_EXCS
, FF_FORMULAS_F DFLT_EXCS_TRTMT2
, FF_FORMULAS_F PCT_RNDG2
, FF_FORMULAS_F VAL_RNDG2
WHERE FUSER.USER_ID (+)= BPP.LAST_UPDATED_BY
AND PLIP.PLIP_ID (+)= BPP.PLIP_ID
AND PL.PL_ID (+)= PLIP.PL_ID
AND PTIP.PTIP_ID (+)= BPP.PTIP_ID
AND PL_TYP.PL_TYP_ID (+)= PTIP.PL_TYP_ID
AND PGM.PGM_ID (+)= BPP.PGM_ID
AND OIPLIP.OIPLIP_ID (+)= BPP.OIPLIP_ID
AND OIPL.OIPL_ID (+) = OIPLIP.OIPL_ID
AND OPT.OPT_ID (+) = OIPL.OPT_ID
AND PCT_RNDG.LOOKUP_CODE (+)= BPP.PCT_RNDG_CD
AND PCT_RNDG.LOOKUP_TYPE (+)= 'BEN_RNDG'
AND VAL_RNDG.LOOKUP_CODE (+)= BPP.VAL_RNDG_CD
AND VAL_RNDG.LOOKUP_TYPE (+)= 'BEN_RNDG'
AND DFLT_EXCS_TRTMT.LOOKUP_CODE (+)= BPP.DFLT_EXCS_TRTMT_CD
AND DFLT_EXCS_TRTMT.LOOKUP_TYPE (+)= 'BEN_DFLT_EXCS_TRTMT'
AND RLOVR_RSTRCN.LOOKUP_CODE (+)= BPP.RLOVR_RSTRCN_CD
AND RLOVR_RSTRCN.LOOKUP_TYPE (+)= 'BEN_RLOVR_RSTRN'
AND EXCS_TRTMT.LOOKUP_CODE (+)= BPP.EXCS_TRTMT_CD
AND EXCS_TRTMT.LOOKUP_TYPE (+)= 'BEN_EXCS_TRTMT'
AND PGM_POOL.LOOKUP_CODE (+)= BPP.PGM_POOL_FLAG
AND PGM_POOL.LOOKUP_TYPE (+)= 'YES_NO'
AND EXCS_ALWYS_FFTD.LOOKUP_CODE (+)= BPP.EXCS_ALWYS_FFTD_FLAG
AND EXCS_ALWYS_FFTD.LOOKUP_TYPE (+)= 'YES_NO'
AND USE_FOR_PGM_POOL.LOOKUP_CODE (+)= BPP.USE_FOR_PGM_POOL_FLAG
AND USE_FOR_PGM_POOL.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MN_DSTRBL_PCT.LOOKUP_CODE (+)= BPP.NO_MN_DSTRBL_PCT_FLAG
AND NO_MN_DSTRBL_PCT.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MN_DSTRBL_VAL.LOOKUP_CODE (+)= BPP.NO_MN_DSTRBL_VAL_FLAG
AND NO_MN_DSTRBL_VAL.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MX_DSTRBL_PCT.LOOKUP_CODE (+)= BPP.NO_MX_DSTRBL_PCT_FLAG
AND NO_MX_DSTRBL_PCT.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MX_DSTRBL_VAL.LOOKUP_CODE (+)= BPP.NO_MX_DSTRBL_VAL_FLAG
AND NO_MX_DSTRBL_VAL.LOOKUP_TYPE (+)= 'YES_NO'
AND AUTO_ALCT_EXCS.LOOKUP_CODE (+)= BPP.AUTO_ALCT_EXCS_FLAG
AND AUTO_ALCT_EXCS.LOOKUP_TYPE (+)= 'YES_NO'
AND DFLT_EXCS_TRTMT2.FORMULA_ID (+)= BPP.DFLT_EXCS_TRTMT_RL
AND PCT_RNDG2.FORMULA_ID (+)= BPP.PCT_RNDG_RL
AND VAL_RNDG2.FORMULA_ID (+)= BPP.VAL_RNDG_RL

Columns