VIEW: APPS.BEN_ENRT_OVERRIDE_RATES_V

Source

View Text - Preformatted

SELECT abr.rt_typ_cd rt_typ_cd, abr.tx_typ_cd tx_typ_cd, abr.acty_typ_cd acty_typ_cd, abr.rt_mlt_cd mlt_cd, abr.val rt_val, f.effective_date rt_strt_dt, to_date(12/'31/4712','MM/DD/rrrr') rt_end_dt, null ann_rt_val, abr.bnft_rt_typ_cd bnft_rt_typ_cd, null cmcd_rt_val, abr.dsply_on_enrt_flag dsply_on_enrt_flag, f.effective_date elctns_made_dt, 'Y' rt_ovridn_flag, abr.business_group_id business_group_id, abr.acty_base_rt_id acty_base_rt_id, abr.input_value_id input_value_id, abr.element_type_id element_type_id, abr.pl_id pl_id, abr.oipl_id oipl_id, abr.pgm_id pgm_id, abr.plip_id plip_id, abr.ptip_id ptip_id, abr.oiplip_id oiplip_id from ben_acty_base_rt_f abr, fnd_sessions f WHERE f.session_id = userenv('sessionid') and abr.rt_usg_cd <> 'FLXCR' and (abr.entr_val_at_enrt_flag = 'Y' or abr.asn_on_enrt_flag = 'Y') and f.effective_date between abr.effective_start_date and abr.effective_end_date

View Text - HTML Formatted

SELECT ABR.RT_TYP_CD RT_TYP_CD
, ABR.TX_TYP_CD TX_TYP_CD
, ABR.ACTY_TYP_CD ACTY_TYP_CD
, ABR.RT_MLT_CD MLT_CD
, ABR.VAL RT_VAL
, F.EFFECTIVE_DATE RT_STRT_DT
, TO_DATE(12/'31/4712'
, 'MM/DD/RRRR') RT_END_DT
, NULL ANN_RT_VAL
, ABR.BNFT_RT_TYP_CD BNFT_RT_TYP_CD
, NULL CMCD_RT_VAL
, ABR.DSPLY_ON_ENRT_FLAG DSPLY_ON_ENRT_FLAG
, F.EFFECTIVE_DATE ELCTNS_MADE_DT
, 'Y' RT_OVRIDN_FLAG
, ABR.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ABR.ACTY_BASE_RT_ID ACTY_BASE_RT_ID
, ABR.INPUT_VALUE_ID INPUT_VALUE_ID
, ABR.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, ABR.PL_ID PL_ID
, ABR.OIPL_ID OIPL_ID
, ABR.PGM_ID PGM_ID
, ABR.PLIP_ID PLIP_ID
, ABR.PTIP_ID PTIP_ID
, ABR.OIPLIP_ID OIPLIP_ID
FROM BEN_ACTY_BASE_RT_F ABR
, FND_SESSIONS F
WHERE F.SESSION_ID = USERENV('SESSIONID')
AND ABR.RT_USG_CD <> 'FLXCR'
AND (ABR.ENTR_VAL_AT_ENRT_FLAG = 'Y' OR ABR.ASN_ON_ENRT_FLAG = 'Y')
AND F.EFFECTIVE_DATE BETWEEN ABR.EFFECTIVE_START_DATE
AND ABR.EFFECTIVE_END_DATE