VIEW: APPS.BENBV_ACTY_BASE_RT_V

Source

View Text - Preformatted

SELECT ABR.EFFECTIVE_START_DATE, ABR.EFFECTIVE_END_DATE, ABR.PRORT_MN_ANN_ELCN_VAL_RL, ABR.PRORT_MX_ANN_ELCN_VAL_RL, ABR.RNDG_RL, ABR.PRTL_MO_EFF_DT_DET_RL, ABR.NAME, ABR.PRTL_MO_DET_MTHD_RL, ABR.VAL_CALC_RL, ABR.MN_ELCN_VAL, ABR.MX_ELCN_VAL, ABR.NNMNTRY_UOM, HR_BIS.BIS_DECODE_LOOKUP('BEN_NNMNTRY_UOM',ABR.NNMNTRY_UOM), ABR.VAL, ABR.INCRMT_ELCN_VAL, ABR.DFLT_VAL, ABR.FRGN_ERG_DED_NAME, ABR.FRGN_ERG_DED_IDENT, ABR.ANN_MN_ELCN_VAL, ABR.ANN_MX_ELCN_VAL, ABR.LWR_LMT_VAL, ABR.LWR_LMT_CALC_RL, ABR.UPR_LMT_VAL, ABR.UPR_LMT_CALC_RL, ABR.WSH_RL_DY_MO_NUM, ABR.INPUT_VA_CALC_RL, ABR.ORDR_NUM, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_ORDR_NUM',ABR.ORDR_NUM), CASE WHEN (ABR.PL_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_PL_NAME(ABR.PL_ID,ABR.BUSINESS_GROUP_ID,ABR.EFFECTIVE_START_DATE) WHEN (ABR.PGM_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_PGM_NAME(ABR.PGM_ID,ABR.BUSINESS_GROUP_ID,ABR.EFFECTIVE_START_DATE) WHEN (ABR.OIPL_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_OIPL_NAME(ABR.OIPL_ID,ABR.BUSINESS_GROUP_ID,ABR.EFFECTIVE_START_DATE) WHEN (ABR.OIPLIP_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_OIPLIP_NAME(ABR.OIPLIP_ID,ABR.BUSINESS_GROUP_ID,ABR.EFFECTIVE_START_DATE) WHEN (ABR.OPT_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_OPT_NAME(ABR.OPT_ID,ABR.BUSINESS_GROUP_ID,ABR.EFFECTIVE_START_DATE) WHEN (ABR.PLIP_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_PLIP_NAME(ABR.PLIP_ID,ABR.BUSINESS_GROUP_ID,ABR.EFFECTIVE_START_DATE) WHEN (ABR.PTIP_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_PTIP_NAME(ABR.PTIP_ID,ABR.BUSINESS_GROUP_ID,ABR.EFFECTIVE_START_DATE) WHEN (ABR.CMBN_PLIP_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_CMBN_PLIP_NAME(ABR.CMBN_PLIP_ID,ABR.BUSINESS_GROUP_ID,ABR.EFFECTIVE_START_DATE) WHEN (ABR.CMBN_PTIP_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_CMBN_PTIP_NAME(ABR.CMBN_PTIP_ID,ABR.BUSINESS_GROUP_ID,ABR.EFFECTIVE_START_DATE) WHEN (ABR.CMBN_PTIP_OPT_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_CMBN_PTIP_OPT_NAME(ABR.CMBN_PTIP_OPT_ID,ABR.BUSINESS_GROUP_ID,ABR.EFFECTIVE_START_DATE) ELSE NULL END COMP_OBJECT, ABR.ONE_ANN_PYMT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ONE_ANN_PYMT',ABR.ONE_ANN_PYMT_CD), ABR.PRORT_MN_ANN_ELCN_VAL_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRORT_ANN_ELCN_VAL',ABR.PRORT_MN_ANN_ELCN_VAL_CD), ABR.PRORT_MX_ANN_ELCN_VAL_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRORT_ANN_ELCN_VAL',ABR.PRORT_MX_ANN_ELCN_VAL_CD), ABR.ACTY_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ACTY_TYP',ABR.ACTY_TYP_CD), ABR.RT_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_TYP',ABR.RT_TYP_CD), ABR.BNFT_RT_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_TYP',ABR.BNFT_RT_TYP_CD), ABR.TX_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_TX_TYP',ABR.TX_TYP_CD), ABR.PARNT_CHLD_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRNT_CHLD',ABR.PARNT_CHLD_CD), ABR.RT_MLT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_MLT',ABR.RT_MLT_CD), ABR.RCRRG_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_RCRRG',ABR.RCRRG_CD), ABR.RNDG_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG',ABR.RNDG_CD), ABR.PRTL_MO_DET_MTHD_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTL_MO_DET_MTHD',ABR.PRTL_MO_DET_MTHD_CD), ABR.ACTY_BASE_RT_STAT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_STAT',ABR.ACTY_BASE_RT_STAT_CD), ABR.PROCG_SRC_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PROCG_SRC',ABR.PROCG_SRC_CD), ABR.FRGN_ERG_DED_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ERG_DED',ABR.FRGN_ERG_DED_TYP_CD), ABR.PRTL_MO_EFF_DT_DET_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTL_MO_EFF_DT_DET',ABR.PRTL_MO_EFF_DT_DET_CD), ABR.RT_USG_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_USG',ABR.RT_USG_CD), ABR.ASMT_TO_USE_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ASMT_TO_USE',ABR.ASMT_TO_USE_CD), ABR.DET_PL_YTD_CNTRS_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_DET_PL_YTD_CNTRS',ABR.DET_PL_YTD_CNTRS_CD), ABR.ALWS_CHG_CD, HR_BIS.BIS_DECODE_LOOKUP('LOOKUP_NOT_FOUND',ABR.ALWS_CHG_CD), ABR.ELE_ENTRY_VAL_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ELE_ENTRY_VAL',ABR.ELE_ENTRY_VAL_CD), ABR.USE_TO_CALC_NET_FLX_CR_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.USE_TO_CALC_NET_FLX_CR_FLAG), ABR.ASN_ON_ENRT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.ASN_ON_ENRT_FLAG), ABR.ABV_MX_ELCN_VAL_ALWD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.ABV_MX_ELCN_VAL_ALWD_FLAG), ABR.BLW_MN_ELCN_ALWD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.BLW_MN_ELCN_ALWD_FLAG), ABR.DSPLY_ON_ENRT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.DSPLY_ON_ENRT_FLAG), ABR.USE_CALC_ACTY_BS_RT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.USE_CALC_ACTY_BS_RT_FLAG), ABR.USES_DED_SCHED_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.USES_DED_SCHED_FLAG), ABR.USES_VARBL_RT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.USES_VARBL_RT_FLAG), ABR.VSTG_SCHED_APLS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.VSTG_SCHED_APLS_FLAG), ABR.PROC_EACH_PP_DFLT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.PROC_EACH_PP_DFLT_FLAG), ABR.PRDCT_FLX_CR_WHEN_ELIG_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.PRDCT_FLX_CR_WHEN_ELIG_FLAG), ABR.NO_STD_RT_USED_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.NO_STD_RT_USED_FLAG), ABR.USES_PYMT_SCHED_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.USES_PYMT_SCHED_FLAG), ABR.VAL_OVRID_ALWD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.VAL_OVRID_ALWD_FLAG), ABR.DFLT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.DFLT_FLAG), ABR.NO_MX_ELCN_VAL_DFND_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.NO_MX_ELCN_VAL_DFND_FLAG), ABR.ENTR_VAL_AT_ENRT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.ENTR_VAL_AT_ENRT_FLAG), ABR.NO_MN_ELCN_VAL_DFND_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.NO_MN_ELCN_VAL_DFND_FLAG), ABR.ONLY_ONE_BAL_TYP_ALWD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.ONLY_ONE_BAL_TYP_ALWD_FLAG), ABR.ENTR_ANN_VAL_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.ENTR_ANN_VAL_FLAG), ABR.ELE_RQD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.ELE_RQD_FLAG), ABR.SUBJ_TO_IMPTD_INCM_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABR.SUBJ_TO_IMPTD_INCM_FLAG), /* id columns */ ABR.ACTY_BASE_RT_ID, ABR.OIPLIP_ID, ABR.BUSINESS_GROUP_ID, ABR.PARNT_ACTY_BASE_RT_ID, ABR.INPUT_VALUE_ID, ABR.ELEMENT_TYPE_ID, ABR.CMBN_PLIP_ID, ABR.PGM_ID, ABR.PL_ID, ABR.OIPL_ID, ABR.PLIP_ID, ABR.PTIP_ID, ABR.CMBN_PTIP_ID, ABR.CMBN_PTIP_OPT_ID, ABR.COMP_LVL_FCTR_ID, ABR.VSTG_FOR_ACTY_RT_ID, ABR.PTD_COMP_LVL_FCTR_ID, ABR.CLM_COMP_LVL_FCTR_ID, ABR.ACTL_PREM_ID, ABR.TTL_COMP_LVL_FCTR_ID, ABR.COST_ALLOCATION_KEYFLEX_ID, ABR.PAY_RATE_GRADE_RULE_ID, ABR.OPT_ID, ABR.RATE_PERIODIZATION_CD, HR_BIS.BIS_DECODE_LOOKUP('LOOKUP_NOT_FOUND',ABR.RATE_PERIODIZATION_CD), ABR.RATE_PERIODIZATION_RL, ABR.SUB_ACTY_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_SUB_ACTY_TYP',ABR.SUB_ACTY_TYP_CD), /* who columns */ ABR.LAST_UPDATE_DATE, ABR.LAST_UPDATED_BY, ABR.CREATED_BY, ABR.CREATION_DATE, /* descriptive flexfield */ '_DF:BEN:BEN_ACTY_BASE_RT_F:ABR' /* codes */ FROM BEN_ACTY_BASE_RT_F ABR WHERE ABR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, ABR.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT ABR.EFFECTIVE_START_DATE
, ABR.EFFECTIVE_END_DATE
, ABR.PRORT_MN_ANN_ELCN_VAL_RL
, ABR.PRORT_MX_ANN_ELCN_VAL_RL
, ABR.RNDG_RL
, ABR.PRTL_MO_EFF_DT_DET_RL
, ABR.NAME
, ABR.PRTL_MO_DET_MTHD_RL
, ABR.VAL_CALC_RL
, ABR.MN_ELCN_VAL
, ABR.MX_ELCN_VAL
, ABR.NNMNTRY_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_NNMNTRY_UOM'
, ABR.NNMNTRY_UOM)
, ABR.VAL
, ABR.INCRMT_ELCN_VAL
, ABR.DFLT_VAL
, ABR.FRGN_ERG_DED_NAME
, ABR.FRGN_ERG_DED_IDENT
, ABR.ANN_MN_ELCN_VAL
, ABR.ANN_MX_ELCN_VAL
, ABR.LWR_LMT_VAL
, ABR.LWR_LMT_CALC_RL
, ABR.UPR_LMT_VAL
, ABR.UPR_LMT_CALC_RL
, ABR.WSH_RL_DY_MO_NUM
, ABR.INPUT_VA_CALC_RL
, ABR.ORDR_NUM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_ORDR_NUM'
, ABR.ORDR_NUM)
, CASE WHEN (ABR.PL_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_PL_NAME(ABR.PL_ID
, ABR.BUSINESS_GROUP_ID
, ABR.EFFECTIVE_START_DATE) WHEN (ABR.PGM_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_PGM_NAME(ABR.PGM_ID
, ABR.BUSINESS_GROUP_ID
, ABR.EFFECTIVE_START_DATE) WHEN (ABR.OIPL_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_OIPL_NAME(ABR.OIPL_ID
, ABR.BUSINESS_GROUP_ID
, ABR.EFFECTIVE_START_DATE) WHEN (ABR.OIPLIP_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_OIPLIP_NAME(ABR.OIPLIP_ID
, ABR.BUSINESS_GROUP_ID
, ABR.EFFECTIVE_START_DATE) WHEN (ABR.OPT_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_OPT_NAME(ABR.OPT_ID
, ABR.BUSINESS_GROUP_ID
, ABR.EFFECTIVE_START_DATE) WHEN (ABR.PLIP_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_PLIP_NAME(ABR.PLIP_ID
, ABR.BUSINESS_GROUP_ID
, ABR.EFFECTIVE_START_DATE) WHEN (ABR.PTIP_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_PTIP_NAME(ABR.PTIP_ID
, ABR.BUSINESS_GROUP_ID
, ABR.EFFECTIVE_START_DATE) WHEN (ABR.CMBN_PLIP_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_CMBN_PLIP_NAME(ABR.CMBN_PLIP_ID
, ABR.BUSINESS_GROUP_ID
, ABR.EFFECTIVE_START_DATE) WHEN (ABR.CMBN_PTIP_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_CMBN_PTIP_NAME(ABR.CMBN_PTIP_ID
, ABR.BUSINESS_GROUP_ID
, ABR.EFFECTIVE_START_DATE) WHEN (ABR.CMBN_PTIP_OPT_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_CMBN_PTIP_OPT_NAME(ABR.CMBN_PTIP_OPT_ID
, ABR.BUSINESS_GROUP_ID
, ABR.EFFECTIVE_START_DATE) ELSE NULL END COMP_OBJECT
, ABR.ONE_ANN_PYMT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ONE_ANN_PYMT'
, ABR.ONE_ANN_PYMT_CD)
, ABR.PRORT_MN_ANN_ELCN_VAL_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRORT_ANN_ELCN_VAL'
, ABR.PRORT_MN_ANN_ELCN_VAL_CD)
, ABR.PRORT_MX_ANN_ELCN_VAL_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRORT_ANN_ELCN_VAL'
, ABR.PRORT_MX_ANN_ELCN_VAL_CD)
, ABR.ACTY_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ACTY_TYP'
, ABR.ACTY_TYP_CD)
, ABR.RT_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_TYP'
, ABR.RT_TYP_CD)
, ABR.BNFT_RT_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_TYP'
, ABR.BNFT_RT_TYP_CD)
, ABR.TX_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TX_TYP'
, ABR.TX_TYP_CD)
, ABR.PARNT_CHLD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRNT_CHLD'
, ABR.PARNT_CHLD_CD)
, ABR.RT_MLT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_MLT'
, ABR.RT_MLT_CD)
, ABR.RCRRG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RCRRG'
, ABR.RCRRG_CD)
, ABR.RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, ABR.RNDG_CD)
, ABR.PRTL_MO_DET_MTHD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTL_MO_DET_MTHD'
, ABR.PRTL_MO_DET_MTHD_CD)
, ABR.ACTY_BASE_RT_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_STAT'
, ABR.ACTY_BASE_RT_STAT_CD)
, ABR.PROCG_SRC_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PROCG_SRC'
, ABR.PROCG_SRC_CD)
, ABR.FRGN_ERG_DED_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ERG_DED'
, ABR.FRGN_ERG_DED_TYP_CD)
, ABR.PRTL_MO_EFF_DT_DET_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTL_MO_EFF_DT_DET'
, ABR.PRTL_MO_EFF_DT_DET_CD)
, ABR.RT_USG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_USG'
, ABR.RT_USG_CD)
, ABR.ASMT_TO_USE_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ASMT_TO_USE'
, ABR.ASMT_TO_USE_CD)
, ABR.DET_PL_YTD_CNTRS_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_DET_PL_YTD_CNTRS'
, ABR.DET_PL_YTD_CNTRS_CD)
, ABR.ALWS_CHG_CD
, HR_BIS.BIS_DECODE_LOOKUP('LOOKUP_NOT_FOUND'
, ABR.ALWS_CHG_CD)
, ABR.ELE_ENTRY_VAL_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ELE_ENTRY_VAL'
, ABR.ELE_ENTRY_VAL_CD)
, ABR.USE_TO_CALC_NET_FLX_CR_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.USE_TO_CALC_NET_FLX_CR_FLAG)
, ABR.ASN_ON_ENRT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.ASN_ON_ENRT_FLAG)
, ABR.ABV_MX_ELCN_VAL_ALWD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.ABV_MX_ELCN_VAL_ALWD_FLAG)
, ABR.BLW_MN_ELCN_ALWD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.BLW_MN_ELCN_ALWD_FLAG)
, ABR.DSPLY_ON_ENRT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.DSPLY_ON_ENRT_FLAG)
, ABR.USE_CALC_ACTY_BS_RT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.USE_CALC_ACTY_BS_RT_FLAG)
, ABR.USES_DED_SCHED_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.USES_DED_SCHED_FLAG)
, ABR.USES_VARBL_RT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.USES_VARBL_RT_FLAG)
, ABR.VSTG_SCHED_APLS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.VSTG_SCHED_APLS_FLAG)
, ABR.PROC_EACH_PP_DFLT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.PROC_EACH_PP_DFLT_FLAG)
, ABR.PRDCT_FLX_CR_WHEN_ELIG_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.PRDCT_FLX_CR_WHEN_ELIG_FLAG)
, ABR.NO_STD_RT_USED_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.NO_STD_RT_USED_FLAG)
, ABR.USES_PYMT_SCHED_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.USES_PYMT_SCHED_FLAG)
, ABR.VAL_OVRID_ALWD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.VAL_OVRID_ALWD_FLAG)
, ABR.DFLT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.DFLT_FLAG)
, ABR.NO_MX_ELCN_VAL_DFND_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.NO_MX_ELCN_VAL_DFND_FLAG)
, ABR.ENTR_VAL_AT_ENRT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.ENTR_VAL_AT_ENRT_FLAG)
, ABR.NO_MN_ELCN_VAL_DFND_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.NO_MN_ELCN_VAL_DFND_FLAG)
, ABR.ONLY_ONE_BAL_TYP_ALWD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.ONLY_ONE_BAL_TYP_ALWD_FLAG)
, ABR.ENTR_ANN_VAL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.ENTR_ANN_VAL_FLAG)
, ABR.ELE_RQD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.ELE_RQD_FLAG)
, ABR.SUBJ_TO_IMPTD_INCM_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABR.SUBJ_TO_IMPTD_INCM_FLAG)
, /* ID COLUMNS */ ABR.ACTY_BASE_RT_ID
, ABR.OIPLIP_ID
, ABR.BUSINESS_GROUP_ID
, ABR.PARNT_ACTY_BASE_RT_ID
, ABR.INPUT_VALUE_ID
, ABR.ELEMENT_TYPE_ID
, ABR.CMBN_PLIP_ID
, ABR.PGM_ID
, ABR.PL_ID
, ABR.OIPL_ID
, ABR.PLIP_ID
, ABR.PTIP_ID
, ABR.CMBN_PTIP_ID
, ABR.CMBN_PTIP_OPT_ID
, ABR.COMP_LVL_FCTR_ID
, ABR.VSTG_FOR_ACTY_RT_ID
, ABR.PTD_COMP_LVL_FCTR_ID
, ABR.CLM_COMP_LVL_FCTR_ID
, ABR.ACTL_PREM_ID
, ABR.TTL_COMP_LVL_FCTR_ID
, ABR.COST_ALLOCATION_KEYFLEX_ID
, ABR.PAY_RATE_GRADE_RULE_ID
, ABR.OPT_ID
, ABR.RATE_PERIODIZATION_CD
, HR_BIS.BIS_DECODE_LOOKUP('LOOKUP_NOT_FOUND'
, ABR.RATE_PERIODIZATION_CD)
, ABR.RATE_PERIODIZATION_RL
, ABR.SUB_ACTY_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_SUB_ACTY_TYP'
, ABR.SUB_ACTY_TYP_CD)
, /* WHO COLUMNS */ ABR.LAST_UPDATE_DATE
, ABR.LAST_UPDATED_BY
, ABR.CREATED_BY
, ABR.CREATION_DATE
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_ACTY_BASE_RT_F:ABR' /* CODES */
FROM BEN_ACTY_BASE_RT_F ABR
WHERE ABR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ABR.BUSINESS_GROUP_ID) WITH READ ONLY