View: BEN_BNFT_POOL_RLOVR_RQMT_D

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

View Text

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

Columns