VIEW: APPS.BEN_BNFT_PRVDR_POOL_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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