[Home] [Help] [Dependency Information]

VIEW: APPS.BENBV_ACTY_BASE_RT_V

Object Details

Object Name:	BENBV_ACTY_BASE_RT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BEN.BENBV_ACTY_BASE_RT_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PRORT_MN_ANN_ELCN_VAL_RL
,      PRORT_MX_ANN_ELCN_VAL_RL
,      RNDG_RL
,      PRTL_MO_EFF_DT_DET_RL
,      NAME
,      PRTL_MO_DET_MTHD_RL
,      VAL_CALC_RL
,      MN_ELCN_VAL
,      MX_ELCN_VAL
,      NNMNTRY_UOM
,      NNMNTRY_UOM_M
,      VAL
,      INCRMT_ELCN_VAL
,      DFLT_VAL
,      FRGN_ERG_DED_NAME
,      FRGN_ERG_DED_IDENT
,      ANN_MN_ELCN_VAL
,      ANN_MX_ELCN_VAL
,      LWR_LMT_VAL
,      LWR_LMT_CALC_RL
,      UPR_LMT_VAL
,      UPR_LMT_CALC_RL
,      WSH_RL_DY_MO_NUM
,      INPUT_VA_CALC_RL
,      ORDR_NUM
,      ORDR_NUM_M
,      COMP_OBJECT
,      ONE_ANN_PYMT_CD
,      ONE_ANN_PYMT_CD_M
,      PRORT_MN_ANN_ELCN_VAL_CD
,      PRORT_MN_ANN_ELCN_VAL_CD_M
,      PRORT_MX_ANN_ELCN_VAL_CD
,      PRORT_MX_ANN_ELCN_VAL_CD_M
,      ACTY_TYP_CD
,      ACTY_TYP_CD_M
,      RT_TYP_CD
,      RT_TYP_CD_M
,      BNFT_RT_TYP_CD
,      BNFT_RT_TYP_CD_M
,      TX_TYP_CD
,      TX_TYP_CD_M
,      PARNT_CHLD_CD
,      PARNT_CHLD_CD_M
,      RT_MLT_CD
,      RT_MLT_CD_M
,      RCRRG_CD
,      RCRRG_CD_M
,      RNDG_CD
,      RNDG_CD_M
,      PRTL_MO_DET_MTHD_CD
,      PRTL_MO_DET_MTHD_CD_M
,      ACTY_BASE_RT_STAT_CD
,      ACTY_BASE_RT_STAT_CD_M
,      PROCG_SRC_CD
,      PROCG_SRC_CD_M
,      FRGN_ERG_DED_TYP_CD
,      FRGN_ERG_DED_TYP_CD_M
,      PRTL_MO_EFF_DT_DET_CD
,      PRTL_MO_EFF_DT_DET_CD_M
,      RT_USG_CD
,      RT_USG_CD_M
,      ASMT_TO_USE_CD
,      ASMT_TO_USE_CD_M
,      DET_PL_YTD_CNTRS_CD
,      DET_PL_YTD_CNTRS_CD_M
,      ALWS_CHG_CD
,      ALWS_CHG_CD_M
,      ELE_ENTRY_VAL_CD
,      ELE_ENTRY_VAL_CD_M
,      USE_TO_CALC_NET_FLX_CR_FLAG
,      USE_TO_CALC_NET_FLX_CR_FLAG_M
,      ASN_ON_ENRT_FLAG
,      ASN_ON_ENRT_FLAG_M
,      ABV_MX_ELCN_VAL_ALWD_FLAG
,      ABV_MX_ELCN_VAL_ALWD_FLAG_M
,      BLW_MN_ELCN_ALWD_FLAG
,      BLW_MN_ELCN_ALWD_FLAG_M
,      DSPLY_ON_ENRT_FLAG
,      DSPLY_ON_ENRT_FLAG_M
,      USE_CALC_ACTY_BS_RT_FLAG
,      USE_CALC_ACTY_BS_RT_FLAG_M
,      USES_DED_SCHED_FLAG
,      USES_DED_SCHED_FLAG_M
,      USES_VARBL_RT_FLAG
,      USES_VARBL_RT_FLAG_M
,      VSTG_SCHED_APLS_FLAG
,      VSTG_SCHED_APLS_FLAG_M
,      PROC_EACH_PP_DFLT_FLAG
,      PROC_EACH_PP_DFLT_FLAG_M
,      PRDCT_FLX_CR_WHEN_ELIG_FLAG
,      PRDCT_FLX_CR_WHEN_ELIG_FLAG_M
,      NO_STD_RT_USED_FLAG
,      NO_STD_RT_USED_FLAG_M
,      USES_PYMT_SCHED_FLAG
,      USES_PYMT_SCHED_FLAG_M
,      VAL_OVRID_ALWD_FLAG
,      VAL_OVRID_ALWD_FLAG_M
,      DFLT_FLAG
,      DFLT_FLAG_M
,      NO_MX_ELCN_VAL_DFND_FLAG
,      NO_MX_ELCN_VAL_DFND_FLAG_M
,      ENTR_VAL_AT_ENRT_FLAG
,      ENTR_VAL_AT_ENRT_FLAG_M
,      NO_MN_ELCN_VAL_DFND_FLAG
,      NO_MN_ELCN_VAL_DFND_FLAG_M
,      ONLY_ONE_BAL_TYP_ALWD_FLAG
,      ONLY_ONE_BAL_TYP_ALWD_FLAG_M
,      ENTR_ANN_VAL_FLAG
,      ENTR_ANN_VAL_FLAG_M
,      ELE_RQD_FLAG
,      ELE_RQD_FLAG_M
,      SUBJ_TO_IMPTD_INCM_FLAG
,      SUBJ_TO_IMPTD_INCM_FLAG_M
,      ACTY_BASE_RT_ID
,      OIPLIP_ID
,      BUSINESS_GROUP_ID
,      PARNT_ACTY_BASE_RT_ID
,      INPUT_VALUE_ID
,      ELEMENT_TYPE_ID
,      CMBN_PLIP_ID
,      PGM_ID
,      PL_ID
,      OIPL_ID
,      PLIP_ID
,      PTIP_ID
,      CMBN_PTIP_ID
,      CMBN_PTIP_OPT_ID
,      COMP_LVL_FCTR_ID
,      VSTG_FOR_ACTY_RT_ID
,      PTD_COMP_LVL_FCTR_ID
,      CLM_COMP_LVL_FCTR_ID
,      ACTL_PREM_ID
,      TTL_COMP_LVL_FCTR_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      PAY_RATE_GRADE_RULE_ID
,      OPT_ID
,      RATE_PERIODIZATION_CD
,      RATE_PERIODIZATION_CD_M
,      RATE_PERIODIZATION_RL
,      SUB_ACTY_TYP_CD
,      SUB_ACTY_TYP_CD_M
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      _DF:ABR
FROM APPS.BENBV_ACTY_BASE_RT_V;

Dependencies

[top of page]

APPS

BEN_ACTY_BASE_RT_F

BEN_BIS_UTILS - show dependent code

HR_BIS - show dependent code

APPS.BENBV_ACTY_BASE_RT_V is not referenced by any database object