VIEW: APPS.BEN_ACTY_BASE_RT_V

Source

View Text - Preformatted

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.CONTEXT_PGM_ID ,ABR.CONTEXT_PL_ID ,ABR.CONTEXT_OPT_ID , ABR.CURRENCY_DET_CD , ABR.ELEMENT_DET_RL , ABR.ABR_SEQ_NUM , 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

View Text - HTML Formatted

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.CONTEXT_PGM_ID
, ABR.CONTEXT_PL_ID
, ABR.CONTEXT_OPT_ID
, ABR.CURRENCY_DET_CD
, ABR.ELEMENT_DET_RL
, ABR.ABR_SEQ_NUM
, 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