Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ACTY_BASE_RT_V |
SELECT ABR.ROWID ROW_ID
, ABR.ACTY_BASE_RT_ID
, ABR.EFFECTIVE_START_DATE
, ABR.EFFECTIVE_END_DATE
, ABR.ACTY_TYP_CD
, ABR.NAME
, ABR.RT_TYP_CD
, ABR.BNFT_RT_TYP_CD
, ABR.TX_TYP_CD
, ABR.USE_TO_CALC_NET_FLX_CR_FLAG
, ABR.ASN_ON_ENRT_FLAG
, ABR.ABV_MX_ELCN_VAL_ALWD_FLAG
, ABR.BLW_MN_ELCN_ALWD_FLAG
, ABR.DSPLY_ON_ENRT_FLAG
, ABR.PARNT_CHLD_CD
, ABR.USE_CALC_ACTY_BS_RT_FLAG
, ABR.USES_DED_SCHED_FLAG
, ABR.USES_VARBL_RT_FLAG
, ABR.VSTG_SCHED_APLS_FLAG
, ABR.RT_MLT_CD
, ABR.PROC_EACH_PP_DFLT_FLAG
, ABR.PRDCT_FLX_CR_WHEN_ELIG_FLAG
, ABR.NO_STD_RT_USED_FLAG
, ABR.RCRRG_CD
, ABR.MN_ELCN_VAL
, ABR.MX_ELCN_VAL
, ABR.USES_PYMT_SCHED_FLAG
, ABR.NNMNTRY_UOM
, ABR.VAL
, ABR.INCRMT_ELCN_VAL
, ABR.RNDG_CD
, ABR.VAL_OVRID_ALWD_FLAG
, ABR.PRTL_MO_DET_MTHD_CD
, ABR.ACTY_BASE_RT_STAT_CD
, ABR.PROCG_SRC_CD
, ABR.DFLT_VAL
, ABR.DFLT_FLAG
, ABR.FRGN_ERG_DED_TYP_CD
, ABR.FRGN_ERG_DED_NAME
, ABR.FRGN_ERG_DED_IDENT
, ABR.NO_MX_ELCN_VAL_DFND_FLAG
, ABR.PRTL_MO_DET_MTHD_RL
, ABR.ENTR_VAL_AT_ENRT_FLAG
, ABR.PRTL_MO_EFF_DT_DET_RL
, ABR.RNDG_RL
, ABR.VAL_CALC_RL
, ABR.NO_MN_ELCN_VAL_DFND_FLAG
, ABR.PRTL_MO_EFF_DT_DET_CD
, ABR.ONLY_ONE_BAL_TYP_ALWD_FLAG
, ABR.RT_USG_CD
, ABR.PRORT_MN_ANN_ELCN_VAL_CD
, ABR.PRORT_MN_ANN_ELCN_VAL_RL
, ABR.PRORT_MX_ANN_ELCN_VAL_CD
, ABR.PRORT_MX_ANN_ELCN_VAL_RL
, ABR.ONE_ANN_PYMT_CD
, ABR.ELE_RQD_FLAG
, ABR.SUBJ_TO_IMPTD_INCM_FLAG
, ABR.ELEMENT_TYPE_ID
, ABR.INPUT_VALUE_ID
, ABR.PGM_ID
, ABR.PL_ID
, ABR.OIPL_ID
, ABR.OPT_ID
, ABR.OIPLIP_ID
, ABR.PLIP_ID
, ABR.PTIP_ID
, ABR.CMBN_PTIP_ID
, ABR.CMBN_PTIP_OPT_ID
, ABR.CMBN_PLIP_ID
, ABR.VSTG_FOR_ACTY_RT_ID
, ABR.COMP_LVL_FCTR_ID
, ABR.PARNT_ACTY_BASE_RT_ID
, ABR.LWR_LMT_VAL
, ABR.LWR_LMT_CALC_RL
, ABR.UPR_LMT_VAL
, ABR.UPR_LMT_CALC_RL
, ABR.PTD_COMP_LVL_FCTR_ID
, ABR.CLM_COMP_LVL_FCTR_ID
, ABR.ENTR_ANN_VAL_FLAG
, ABR.ANN_MN_ELCN_VAL
, ABR.ANN_MX_ELCN_VAL
, ABR.WSH_RL_DY_MO_NUM
, ABR.ASMT_TO_USE_CD
, ABR.ACTL_PREM_ID
, ABR.BUSINESS_GROUP_ID
, ABR.ELE_ENTRY_VAL_CD
, ABR.ORDR_NUM
, ABR.RATE_PERIODIZATION_CD
, ABR.RATE_PERIODIZATION_RL
, ABR.MN_MX_ELCN_RL
, ABR.MAPPING_TABLE_NAME
, ABR.MAPPING_TABLE_PK_ID
, ABR.ABR_ATTRIBUTE_CATEGORY
, ABR.ABR_ATTRIBUTE1
, ABR.ABR_ATTRIBUTE2
, ABR.ABR_ATTRIBUTE3
, ABR.ABR_ATTRIBUTE4
, ABR.ABR_ATTRIBUTE5
, ABR.ABR_ATTRIBUTE6
, ABR.ABR_ATTRIBUTE7
, ABR.ABR_ATTRIBUTE8
, ABR.ABR_ATTRIBUTE9
, ABR.ABR_ATTRIBUTE10
, ABR.ABR_ATTRIBUTE11
, ABR.ABR_ATTRIBUTE12
, ABR.ABR_ATTRIBUTE13
, ABR.ABR_ATTRIBUTE14
, ABR.ABR_ATTRIBUTE15
, ABR.ABR_ATTRIBUTE16
, ABR.ABR_ATTRIBUTE17
, ABR.ABR_ATTRIBUTE18
, ABR.ABR_ATTRIBUTE19
, ABR.ABR_ATTRIBUTE20
, ABR.ABR_ATTRIBUTE21
, ABR.ABR_ATTRIBUTE22
, ABR.ABR_ATTRIBUTE23
, ABR.ABR_ATTRIBUTE24
, ABR.ABR_ATTRIBUTE25
, ABR.ABR_ATTRIBUTE26
, ABR.ABR_ATTRIBUTE27
, ABR.ABR_ATTRIBUTE28
, ABR.ABR_ATTRIBUTE29
, ABR.ABR_ATTRIBUTE30
, ABR.LAST_UPDATE_DATE
, ABR.LAST_UPDATED_BY
, ABR.LAST_UPDATE_LOGIN
, ABR.CREATED_BY
, ABR.CREATION_DATE
, ABR.OBJECT_VERSION_NUMBER
, ABR.DET_PL_YTD_CNTRS_CD
, ABR.ALWS_CHG_CD
, ABR.TTL_COMP_LVL_FCTR_ID
, ABR.COST_ALLOCATION_KEYFLEX_ID
, ABR.INPUT_VA_CALC_RL
, ABR.PAY_RATE_GRADE_RULE_ID
, ABR.SUB_ACTY_TYP_CD
FROM BEN_ACTY_BASE_RT_F ABR
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN ABR.EFFECTIVE_START_DATE
AND ABR.EFFECTIVE_END_DATE