VIEW: APPS.BENBV_BNFT_POOL_RLOVR_RQMT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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