VIEW: APPS.BEN_BNFT_POOL_RLOVR_RQMT_D

Source

View Text - Preformatted

SELECT BPR.ROWID ROW_ID, BPR.BNFT_POOL_RLOVR_RQMT_ID ,BPR.EFFECTIVE_START_DATE ,BPR.EFFECTIVE_END_DATE ,NO_MN_RLOVR_PCT_DFND.MEANING ,NO_MX_RLOVR_PCT_DFND.MEANING ,NO_MN_RLOVR_VAL_DFND.MEANING ,NO_MX_RLOVR_VAL_DFND.MEANING ,BPR.RLOVR_VAL_INCRMT_NUM ,RLOVR_VAL.formula_NAME ,BPR.MN_RLOVR_VAL ,BPR.MX_RLOVR_VAL ,VAL_RNDG.MEANING ,PCT_RNDG.MEANING ,BPR.MX_RCHD_DFLT_ORDR_NUM ,BPR.PCT_RLOVR_INCRMT_NUM ,BPR.MN_RLOVR_PCT_NUM ,BPR.MX_RLOVR_PCT_NUM ,ACTY_BASE_RT.NAME ,PRTT_ELIG_RLOVR.formula_NAME ,BNFT_PRVDR_POOL.NAME ,VAL_RNDG2.formula_NAME ,PCT_RNDG2.formula_NAME ,BPR.LAST_UPDATE_DATE ,fuser.USER_NAME from BEN_BNFT_POOL_RLOVR_RQMT_F BPR, fnd_user_view fuser ,BEN_ACTY_BASE_RT_F ACTY_BASE_RT ,BEN_BNFT_PRVDR_POOL_F BNFT_PRVDR_POOL ,hr_lookups VAL_RNDG ,hr_lookups PCT_RNDG ,hr_lookups NO_MN_RLOVR_PCT_DFND ,hr_lookups NO_MX_RLOVR_PCT_DFND ,hr_lookups NO_MN_RLOVR_VAL_DFND ,hr_lookups NO_MX_RLOVR_VAL_DFND ,ff_formulas_f RLOVR_VAL ,ff_formulas_f PRTT_ELIG_RLOVR ,ff_formulas_f VAL_RNDG2 ,ff_formulas_f PCT_RNDG2 WHERE fuser.user_id(+) = bpr.last_updated_by AND acty_base_rt.acty_base_rt_id(+) = bpr.acty_base_rt_id AND bnft_prvdr_pool.bnft_prvdr_pool_id(+) = bpr.bnft_prvdr_pool_id AND val_rndg.lookup_code(+) = bpr.val_rndg_cd AND val_rndg.lookup_type(+) = 'BEN_RNDG' AND pct_rndg.lookup_code(+) = bpr.pct_rndg_cd AND pct_rndg.lookup_type(+) = 'BEN_RNDG' AND no_mn_rlovr_pct_dfnd.lookup_code(+) = bpr.no_mn_rlovr_pct_dfnd_flag AND no_mn_rlovr_pct_dfnd.lookup_type(+) = 'YES_NO' AND no_mx_rlovr_pct_dfnd.lookup_code(+) = bpr.no_mx_rlovr_pct_dfnd_flag AND no_mx_rlovr_pct_dfnd.lookup_type(+) = 'YES_NO' AND no_mn_rlovr_val_dfnd.lookup_code(+) = bpr.no_mn_rlovr_val_dfnd_flag AND no_mn_rlovr_val_dfnd.lookup_type(+) = 'YES_NO' AND no_mx_rlovr_val_dfnd.lookup_code(+) = bpr.no_mx_rlovr_val_dfnd_flag AND no_mx_rlovr_val_dfnd.lookup_type(+) = 'YES_NO' AND rlovr_val.formula_id(+) = bpr.rlovr_val_rl AND bpr.effective_start_date BETWEEN rlovr_val.effective_start_date (+) AND rlovr_val.effective_end_date(+) AND prtt_elig_rlovr.formula_id(+) = bpr.prtt_elig_rlovr_rl AND bpr.effective_start_date BETWEEN prtt_elig_rlovr.effective_start_date(+) AND prtt_elig_rlovr.effective_end_date(+) AND val_rndg2.formula_id(+) = bpr.val_rndg_rl AND bpr.effective_start_date BETWEEN val_rndg2.effective_start_date(+) AND val_rndg2.effective_end_date(+) AND pct_rndg2.formula_id(+) = bpr.pct_rndg_rl AND bpr.effective_start_date BETWEEN pct_rndg2.effective_start_date(+) AND pct_rndg2.effective_end_date(+) AND bpr.effective_start_date BETWEEN bnft_prvdr_pool.effective_start_date AND bnft_prvdr_pool.effective_end_date AND bpr.effective_start_date BETWEEN acty_base_rt.effective_start_date AND acty_base_rt.effective_end_date

View Text - HTML Formatted

SELECT BPR.ROWID ROW_ID
, BPR.BNFT_POOL_RLOVR_RQMT_ID
, BPR.EFFECTIVE_START_DATE
, BPR.EFFECTIVE_END_DATE
, NO_MN_RLOVR_PCT_DFND.MEANING
, NO_MX_RLOVR_PCT_DFND.MEANING
, NO_MN_RLOVR_VAL_DFND.MEANING
, NO_MX_RLOVR_VAL_DFND.MEANING
, BPR.RLOVR_VAL_INCRMT_NUM
, RLOVR_VAL.FORMULA_NAME
, BPR.MN_RLOVR_VAL
, BPR.MX_RLOVR_VAL
, VAL_RNDG.MEANING
, PCT_RNDG.MEANING
, BPR.MX_RCHD_DFLT_ORDR_NUM
, BPR.PCT_RLOVR_INCRMT_NUM
, BPR.MN_RLOVR_PCT_NUM
, BPR.MX_RLOVR_PCT_NUM
, ACTY_BASE_RT.NAME
, PRTT_ELIG_RLOVR.FORMULA_NAME
, BNFT_PRVDR_POOL.NAME
, VAL_RNDG2.FORMULA_NAME
, PCT_RNDG2.FORMULA_NAME
, BPR.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_BNFT_POOL_RLOVR_RQMT_F BPR
, FND_USER_VIEW FUSER
, BEN_ACTY_BASE_RT_F ACTY_BASE_RT
, BEN_BNFT_PRVDR_POOL_F BNFT_PRVDR_POOL
, HR_LOOKUPS VAL_RNDG
, HR_LOOKUPS PCT_RNDG
, HR_LOOKUPS NO_MN_RLOVR_PCT_DFND
, HR_LOOKUPS NO_MX_RLOVR_PCT_DFND
, HR_LOOKUPS NO_MN_RLOVR_VAL_DFND
, HR_LOOKUPS NO_MX_RLOVR_VAL_DFND
, FF_FORMULAS_F RLOVR_VAL
, FF_FORMULAS_F PRTT_ELIG_RLOVR
, FF_FORMULAS_F VAL_RNDG2
, FF_FORMULAS_F PCT_RNDG2
WHERE FUSER.USER_ID(+) = BPR.LAST_UPDATED_BY
AND ACTY_BASE_RT.ACTY_BASE_RT_ID(+) = BPR.ACTY_BASE_RT_ID
AND BNFT_PRVDR_POOL.BNFT_PRVDR_POOL_ID(+) = BPR.BNFT_PRVDR_POOL_ID
AND VAL_RNDG.LOOKUP_CODE(+) = BPR.VAL_RNDG_CD
AND VAL_RNDG.LOOKUP_TYPE(+) = 'BEN_RNDG'
AND PCT_RNDG.LOOKUP_CODE(+) = BPR.PCT_RNDG_CD
AND PCT_RNDG.LOOKUP_TYPE(+) = 'BEN_RNDG'
AND NO_MN_RLOVR_PCT_DFND.LOOKUP_CODE(+) = BPR.NO_MN_RLOVR_PCT_DFND_FLAG
AND NO_MN_RLOVR_PCT_DFND.LOOKUP_TYPE(+) = 'YES_NO'
AND NO_MX_RLOVR_PCT_DFND.LOOKUP_CODE(+) = BPR.NO_MX_RLOVR_PCT_DFND_FLAG
AND NO_MX_RLOVR_PCT_DFND.LOOKUP_TYPE(+) = 'YES_NO'
AND NO_MN_RLOVR_VAL_DFND.LOOKUP_CODE(+) = BPR.NO_MN_RLOVR_VAL_DFND_FLAG
AND NO_MN_RLOVR_VAL_DFND.LOOKUP_TYPE(+) = 'YES_NO'
AND NO_MX_RLOVR_VAL_DFND.LOOKUP_CODE(+) = BPR.NO_MX_RLOVR_VAL_DFND_FLAG
AND NO_MX_RLOVR_VAL_DFND.LOOKUP_TYPE(+) = 'YES_NO'
AND RLOVR_VAL.FORMULA_ID(+) = BPR.RLOVR_VAL_RL
AND BPR.EFFECTIVE_START_DATE BETWEEN RLOVR_VAL.EFFECTIVE_START_DATE (+)
AND RLOVR_VAL.EFFECTIVE_END_DATE(+)
AND PRTT_ELIG_RLOVR.FORMULA_ID(+) = BPR.PRTT_ELIG_RLOVR_RL
AND BPR.EFFECTIVE_START_DATE BETWEEN PRTT_ELIG_RLOVR.EFFECTIVE_START_DATE(+)
AND PRTT_ELIG_RLOVR.EFFECTIVE_END_DATE(+)
AND VAL_RNDG2.FORMULA_ID(+) = BPR.VAL_RNDG_RL
AND BPR.EFFECTIVE_START_DATE BETWEEN VAL_RNDG2.EFFECTIVE_START_DATE(+)
AND VAL_RNDG2.EFFECTIVE_END_DATE(+)
AND PCT_RNDG2.FORMULA_ID(+) = BPR.PCT_RNDG_RL
AND BPR.EFFECTIVE_START_DATE BETWEEN PCT_RNDG2.EFFECTIVE_START_DATE(+)
AND PCT_RNDG2.EFFECTIVE_END_DATE(+)
AND BPR.EFFECTIVE_START_DATE BETWEEN BNFT_PRVDR_POOL.EFFECTIVE_START_DATE
AND BNFT_PRVDR_POOL.EFFECTIVE_END_DATE
AND BPR.EFFECTIVE_START_DATE BETWEEN ACTY_BASE_RT.EFFECTIVE_START_DATE
AND ACTY_BASE_RT.EFFECTIVE_END_DATE