Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ENRT_OVERRIDE_RATES_V |
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