Product: | BEN - Advanced Benefits |
---|---|
Description: | This view specifies the plans or options in plans and the restrictions, if any, into which any excess from a benefit pool may be rolled over to be applied as contributions. |
Implementation/DBA Data: | APPS.BENBV_BNFT_POOL_RLOVR_RQMT_V |
SELECT BPR.EFFECTIVE_START_DATE
, BPR.EFFECTIVE_END_DATE
, BPR.VAL_RNDG_RL
, BPR.PCT_RNDG_RL
, BPR.RLOVR_VAL_INCRMT_NUM
, BPR.RLOVR_VAL_RL
, BPR.MN_RLOVR_VAL
, BPR.MX_RLOVR_VAL
, BPR.MX_RCHD_DFLT_ORDR_NUM
, BPR.PCT_RLOVR_INCRMT_NUM
, BPR.MN_RLOVR_PCT_NUM
, BPR.MX_RLOVR_PCT_NUM
, BPR.PRTT_ELIG_RLOVR_RL
, BPR.MX_PCT_TTL_CRS_CN_ROLL_NUM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_BNFT_POOL_RLOVR_RQMT_F:BPR'
, /* CODES */ BPR.VAL_RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, BPR.VAL_RNDG_CD)
, BPR.PCT_RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, BPR.PCT_RNDG_CD)
, BPR.CRS_RLOVR_PROCG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CRS_RLOVR_PROCG'
, BPR.CRS_RLOVR_PROCG_CD)
, BPR.NO_MN_RLOVR_PCT_DFND_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, BPR.NO_MN_RLOVR_PCT_DFND_FLAG)
, BPR.NO_MX_RLOVR_PCT_DFND_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, BPR.NO_MX_RLOVR_PCT_DFND_FLAG)
, BPR.NO_MN_RLOVR_VAL_DFND_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, BPR.NO_MN_RLOVR_VAL_DFND_FLAG)
, BPR.NO_MX_RLOVR_VAL_DFND_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, BPR.NO_MX_RLOVR_VAL_DFND_FLAG)
, /* ID COLUMNS */ BPR.BNFT_POOL_RLOVR_RQMT_ID
, BPR.BUSINESS_GROUP_ID
, BPR.ACTY_BASE_RT_ID
, BPR.BNFT_PRVDR_POOL_ID
, /* WHO COLUMNS */ BPR.LAST_UPDATE_DATE
, BPR.LAST_UPDATED_BY
, BPR.CREATED_BY
, BPR.CREATION_DATE
FROM BEN_BNFT_POOL_RLOVR_RQMT_F BPR
WHERE BPR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, BPR.BUSINESS_GROUP_ID) WITH READ ONLY