eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.BENBV_ENRT_RT_V

Object Details

Object Name:	BENBV_ENRT_RT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BEN.BENBV_ENRT_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

Name	Datatype	Length	Mandatory	Comments
RT_STRT_DT	DATE			Rate start date.
RT_STRT_DT_RL	NUMBER	(15)		Foreign Key to FF_FORMULAS_F
PROGRAM_UPDATE_DATE	DATE			Program update date.
DFLT_VAL	NUMBER			Default value.
ANN_VAL	NUMBER			Annual Amount.
ANN_MN_ELCN_VAL	NUMBER			Annual minimum.
ANN_MX_ELCN_VAL	NUMBER			Annual maximum.
VAL	NUMBER			Defined amount.
NNMNTRY_UOM	VARCHAR2	(30)		Rate unit of measure (Lookup code based on lookup type BEN_NNMNTRY_UOM).
NNMNTRY_UOM_M	VARCHAR2	(4000)		Rate unit of measure (Lookup meaning based on lookup type BEN_NNMNTRY_UOM).
MX_ELCN_VAL	NUMBER			Maximum defined amount.
MN_ELCN_VAL	NUMBER			Minimum defined amount.
INCRMT_ELCN_VAL	NUMBER			Defined amount increment.
CMCD_MN_ELCN_VAL	NUMBER			Minimum communicated amount.
CMCD_MX_ELCN_VAL	NUMBER			Maximum communicated amount.
CMCD_VAL	NUMBER			Communicated amount.
CMCD_DFLT_VAL	NUMBER			Communicated default amount.
ANN_DFLT_VAL	NUMBER	(15)		Annual default value.
DSPLY_MN_ELCN_VAL	NUMBER	(15)		Display minimum election value.
DSPLY_MX_ELCN_VAL	NUMBER	(15)		Display maximum election value.
ISS_VAL	NUMBER			Defined issued amount.
VAL_LAST_UPD_DATE	DATE			Last updated on.
PP_IN_YR_USED_NUM	NUMBER	(15)		Pay periods in the year used.
ORDR_NUM	NUMBER	(15)		Order number.
_DF:ECR	CHAR	(23)
ACTY_TYP_CD	VARCHAR2	(30)	Yes	Activity type (Lookup code based on lookup type BEN_ACTY_TYP).
ACTY_TYP_CD_M	VARCHAR2	(4000)		Activity type (Lookup meaning based on lookup type BEN_ACTY_TYP).
TX_TYP_CD	VARCHAR2	(30)	Yes	Tax type (Lookup code based on lookup type BEN_TX_TYP).
TX_TYP_CD_M	VARCHAR2	(4000)		Tax type (Lookup meaning based on lookup type BEN_TX_TYP).
RT_STRT_DT_CD	VARCHAR2	(30)		Rate start code (Lookup code based on lookup type BEN_RT_STRT).
RT_STRT_DT_CD_M	VARCHAR2	(4000)		Rate start code (Lookup meaning based on lookup type BEN_RT_STRT).
RT_TYP_CD	VARCHAR2	(30)		Rate type (Lookup code based on lookup type BEN_RT_TYP).
RT_TYP_CD_M	VARCHAR2	(4000)		Rate type (Lookup meaning based on lookup type BEN_RT_TYP).
CMCD_ACTY_REF_PERD_CD	VARCHAR2	(30)		Communicated amount period (Lookup code based on lookup type BEN_ENRT_INFO_RT_FREQ).
CMCD_ACTY_REF_PERD_CD_M	VARCHAR2	(4000)		Communicated amount period (Lookup meaning based on lookup type BEN_ENRT_INFO_RT_FREQ).
RT_USG_CD	VARCHAR2	(30)		Rate usage (Lookup code based on lookup type BEN_RT_USG).
RT_USG_CD_M	VARCHAR2	(4000)		Rate usage (Lookup meaning based on lookup type BEN_RT_USG).
BNFT_RT_TYP_CD	VARCHAR2	(30)		Benefit rate type (Lookup code based on lookup type BEN_BNFT_RT_TYP).
BNFT_RT_TYP_CD_M	VARCHAR2	(4000)		Benefit rate type (Lookup meaning based on lookup type BEN_BNFT_RT_TYP).
RT_MLT_CD	VARCHAR2	(30)		Calculation method (Lookup code based on lookup type BEN_MLT).
RT_MLT_CD_M	VARCHAR2	(4000)		Calculation method (Lookup meaning based on lookup type BEN_MLT).
CTFN_RQD_FLAG	VARCHAR2	(30)	Yes	Certification required (Lookup code based on lookup type YES_NO).
CTFN_RQD_FLAG_M	VARCHAR2	(4000)		Certification required (Lookup meaning based on lookup type YES_NO).
DFLT_FLAG	VARCHAR2	(30)	Yes	Default rate (Lookup code based on lookup type YES_NO).
DFLT_FLAG_M	VARCHAR2	(4000)		Default rate (Lookup meaning based on lookup type YES_NO).
DFLT_PNDG_CTFN_FLAG	VARCHAR2	(30)	Yes	Default pending certification (Lookup code based on lookup type YES_NO).
DFLT_PNDG_CTFN_FLAG_M	VARCHAR2	(4000)		Default pending certification (Lookup meaning based on lookup type YES_NO).
DSPLY_ON_ENRT_FLAG	VARCHAR2	(30)	Yes	Display rate on enrollment (Lookup code based on lookup type YES_NO).
DSPLY_ON_ENRT_FLAG_M	VARCHAR2	(4000)		Display rate on enrollment (Lookup meaning based on lookup type YES_NO).
USE_TO_CALC_NET_FLX_CR_FLAG	VARCHAR2	(30)	Yes	Use to calculate net flexible credit (Lookup code based on lookup type YES_NO).
USE_TO_CALC_NET_FLX_CR_FLAG_M	VARCHAR2	(4000)		Use to calculate net flexible credit (Lookup meaning based on lookup type YES_NO).
ENTR_VAL_AT_ENRT_FLAG	VARCHAR2	(30)	Yes	Enter value at enrollment (Lookup code based on lookup type YES_NO).
ENTR_VAL_AT_ENRT_FLAG_M	VARCHAR2	(4000)		Enter value at enrollment (Lookup meaning based on lookup type YES_NO).
ASN_ON_ENRT_FLAG	VARCHAR2	(30)	Yes	Assign on enrollment (Lookup code based on lookup type YES_NO).
ASN_ON_ENRT_FLAG_M	VARCHAR2	(4000)		Assign on enrollment (Lookup meaning based on lookup type YES_NO).
RL_CRS_ONLY_FLAG	VARCHAR2	(30)	Yes	Rule credits only (Lookup code based on lookup type YES_NO).
RL_CRS_ONLY_FLAG_M	VARCHAR2	(4000)		Rule credits only (Lookup meaning based on lookup type YES_NO).
ENTR_ANN_VAL_FLAG	VARCHAR2	(30)	Yes	Enter annual value (Lookup code based on lookup type YES_NO).
ENTR_ANN_VAL_FLAG_M	VARCHAR2	(4000)		Enter annual value (Lookup meaning based on lookup type YES_NO).
ENRT_RT_ID	NUMBER	(15)	Yes	System generated primary key column.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign Key to HR_ORGANIZATION_UNITS.
ACTY_BASE_RT_ID	NUMBER	(15)	Yes	Foreign key to BEN_ACTY_BASE_RT_F.
ELIG_PER_ELCTBL_CHC_ID	NUMBER	(15)		Foreign key to BEN_ELIG_PER_ELCTBL_CHC.
SPCL_RT_ENRT_RT_ID	NUMBER	(15)		Foreign kry to BEN_ENRT_RT.
ENRT_BNFT_ID	NUMBER	(15)		Foreign key to BEN_ENRT_BNFT.
CVG_AMT_CALC_MTHD_ID	NUMBER	(15)		Foreign key to BEN_CVG_AMT_CALC_MTHD_F.
ACTL_PREM_ID	NUMBER	(15)		Foreign key to BEN_ACTL_PREM_F.
COMP_LVL_FCTR_ID	NUMBER	(15)		Foreign key to BEN_COMP_LVL_FCTR.
PTD_COMP_LVL_FCTR_ID	NUMBER	(15)		Foreign key to BEN_PTD_COMP_LVL_FCTR_F.
CLM_COMP_LVL_FCTR_ID	NUMBER	(15)		Foreign Key to BEN_CLM_COMP_LVL_FCTR_F.
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
DECR_BNFT_PRVDR_POOL_ID	NUMBER	(15)		Foreign Key to DECR_BNFT_PRVDR_POOL_F.
PRTT_RT_VAL_ID	NUMBER	(15)		Foreign key to BEN_PRTT_RT_VAL.
VAL_LAST_UPD_PERSON_ID	NUMBER	(15)		Foreign Key to PER_ALL_PEOPLE_F.
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.

Query Text

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


SELECT RT_STRT_DT
,      RT_STRT_DT_RL
,      PROGRAM_UPDATE_DATE
,      DFLT_VAL
,      ANN_VAL
,      ANN_MN_ELCN_VAL
,      ANN_MX_ELCN_VAL
,      VAL
,      NNMNTRY_UOM
,      NNMNTRY_UOM_M
,      MX_ELCN_VAL
,      MN_ELCN_VAL
,      INCRMT_ELCN_VAL
,      CMCD_MN_ELCN_VAL
,      CMCD_MX_ELCN_VAL
,      CMCD_VAL
,      CMCD_DFLT_VAL
,      ANN_DFLT_VAL
,      DSPLY_MN_ELCN_VAL
,      DSPLY_MX_ELCN_VAL
,      ISS_VAL
,      VAL_LAST_UPD_DATE
,      PP_IN_YR_USED_NUM
,      ORDR_NUM
,      _DF:ECR
,      ACTY_TYP_CD
,      ACTY_TYP_CD_M
,      TX_TYP_CD
,      TX_TYP_CD_M
,      RT_STRT_DT_CD
,      RT_STRT_DT_CD_M
,      RT_TYP_CD
,      RT_TYP_CD_M
,      CMCD_ACTY_REF_PERD_CD
,      CMCD_ACTY_REF_PERD_CD_M
,      RT_USG_CD
,      RT_USG_CD_M
,      BNFT_RT_TYP_CD
,      BNFT_RT_TYP_CD_M
,      RT_MLT_CD
,      RT_MLT_CD_M
,      CTFN_RQD_FLAG
,      CTFN_RQD_FLAG_M
,      DFLT_FLAG
,      DFLT_FLAG_M
,      DFLT_PNDG_CTFN_FLAG
,      DFLT_PNDG_CTFN_FLAG_M
,      DSPLY_ON_ENRT_FLAG
,      DSPLY_ON_ENRT_FLAG_M
,      USE_TO_CALC_NET_FLX_CR_FLAG
,      USE_TO_CALC_NET_FLX_CR_FLAG_M
,      ENTR_VAL_AT_ENRT_FLAG
,      ENTR_VAL_AT_ENRT_FLAG_M
,      ASN_ON_ENRT_FLAG
,      ASN_ON_ENRT_FLAG_M
,      RL_CRS_ONLY_FLAG
,      RL_CRS_ONLY_FLAG_M
,      ENTR_ANN_VAL_FLAG
,      ENTR_ANN_VAL_FLAG_M
,      ENRT_RT_ID
,      BUSINESS_GROUP_ID
,      ACTY_BASE_RT_ID
,      ELIG_PER_ELCTBL_CHC_ID
,      SPCL_RT_ENRT_RT_ID
,      ENRT_BNFT_ID
,      CVG_AMT_CALC_MTHD_ID
,      ACTL_PREM_ID
,      COMP_LVL_FCTR_ID
,      PTD_COMP_LVL_FCTR_ID
,      CLM_COMP_LVL_FCTR_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      DECR_BNFT_PRVDR_POOL_ID
,      PRTT_RT_VAL_ID
,      VAL_LAST_UPD_PERSON_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.BENBV_ENRT_RT_V;

Dependencies

[top of page]

APPS.BENBV_ENRT_RT_V references the following:

APPS: BEN_ENRT_RT; HR_BIS - show dependent code

APPS.BENBV_ENRT_RT_V is not referenced by any database object