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_VRBL_RT_PRFL_V

Object Details

Object Name:	BENBV_VRBL_RT_PRFL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BEN.BENBV_VRBL_RT_PRFL_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
EFFECTIVE_START_DATE	DATE		Yes	Effective start date.
EFFECTIVE_END_DATE	DATE		Yes	Effective end date.
NAME	VARCHAR2	(240)	Yes	Variable profile name.
INCRMNT_ELCN_VAL	NUMBER			Calculation method increment.
DFLT_ELCN_VAL	NUMBER			Calculation method default.
MX_ELCN_VAL	NUMBER			Calculation method min.
MN_ELCN_VAL	NUMBER			Calculation method max.
VAL	NUMBER			Flat amount.
VAL_CALC_RL	NUMBER	(15)		Foreign Key to FF_FORMULAS_F
RNDG_RL	NUMBER	(15)		Foreign Key to FF_FORMULAS_F
LWR_LMT_VAL	NUMBER			Lower limit value.
LWR_LMT_CALC_RL	NUMBER	(15)		Foreign Key to FF_FORMULAS_F
UPR_LMT_VAL	NUMBER			High limit value.
UPR_LMT_CALC_RL	NUMBER	(15)		Foreign Key to FF_FORMULAS_F
ANN_MN_ELCN_VAL	NUMBER			Calculation method annual minimum.
ANN_MX_ELCN_VAL	NUMBER			Calculation method annual maximum.
ULTMT_UPR_LMT	NUMBER			Ultimate high limit value.
ULTMT_LWR_LMT	NUMBER			Ultimate low limit value.
ULTMT_UPR_LMT_CALC_RL	NUMBER	(15)		Foreign Key to FF_FORMULAS_F
ULTMT_LWR_LMT_CALC_RL	NUMBER	(15)		Foreign Key to FF_FORMULAS_F
_DF:VPF	CHAR	(30)
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).
VRBL_RT_TRTMT_CD	VARCHAR2	(30)	Yes	Treatment (Lookup code based on lookup type BEN_RT_TRTMT).
VRBL_RT_TRTMT_CD_M	VARCHAR2	(4000)		Treatment (Lookup meaning based on lookup type BEN_RT_TRTMT).
ACTY_REF_PERD_CD	VARCHAR2	(30)	Yes	Reference period (Lookup code based on lookup type BEN_ACTY_REF_PERD).
ACTY_REF_PERD_CD_M	VARCHAR2	(4000)		Reference period (Lookup meaning based on lookup type BEN_ACTY_REF_PERD).
MLT_CD	VARCHAR2	(30)	Yes	Calculation method (Lookup code based on lookup type BEN_MLT).
MLT_CD_M	VARCHAR2	(4000)		Calculation method (Lookup meaning based on lookup type BEN_MLT).
ASMT_TO_USE_CD	VARCHAR2	(30)	Yes	Assignment to use (Lookup code based on lookup type BEN_ASMT_TO_USE).
ASMT_TO_USE_CD_M	VARCHAR2	(4000)		Assignment to use (Lookup meaning based on lookup type BEN_ASMT_TO_USE).
ACTY_TYP_CD	VARCHAR2	(30)		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).
RT_TYP_CD	VARCHAR2	(30)		Calculation method operator (Lookup code based on lookup type BEN_RT_TYP).
RT_TYP_CD_M	VARCHAR2	(4000)		Calculation method operator (Lookup meaning based on lookup type BEN_RT_TYP).
BNFT_RT_TYP_CD	VARCHAR2	(30)		Calculation method coverage operator (Lookup code based on lookup type BEN_RT_TYP).
BNFT_RT_TYP_CD_M	VARCHAR2	(4000)		Calculation method coverage operator (Lookup meaning based on lookup type BEN_RT_TYP).
VRBL_RT_PRFL_STAT_CD	VARCHAR2	(30)		Status (Lookup code based on lookup type BEN_STAT).
VRBL_RT_PRFL_STAT_CD_M	VARCHAR2	(4000)		Status (Lookup meaning based on lookup type BEN_STAT).
VRBL_USG_CD	VARCHAR2	(30)		Usage (Lookup code based on lookup type BEN_VRBL_USG).
VRBL_USG_CD_M	VARCHAR2	(4000)		Usage (Lookup meaning based on lookup type BEN_VRBL_USG).
RNDG_CD	VARCHAR2	(30)		Calculation method rounding code (Lookup code based on lookup type BEN_RNDG).
RNDG_CD_M	VARCHAR2	(4000)		Calculation method rounding code (Lookup meaning based on lookup type BEN_RNDG).
NO_MN_ELCN_VAL_DFND_FLAG	VARCHAR2	(30)	Yes	Enter at enrollment (Lookup code based on lookup type YES_NO).
NO_MN_ELCN_VAL_DFND_FLAG_M	VARCHAR2	(4000)		Enter at enrollment (Lookup meaning based on lookup type YES_NO).
NO_MX_ELCN_VAL_DFND_FLAG	VARCHAR2	(30)	Yes	No mx elcn val dfnd flag m (Lookup code based on lookup type YES_NO).
NO_MX_ELCN_VAL_DFND_FLAG_M	VARCHAR2	(4000)		No mx elcn val dfnd flag m (Lookup meaning based on lookup type YES_NO).
ALWYS_SUM_ALL_CVG_FLAG	VARCHAR2	(30)	Yes	Always sum all coverage (Lookup code based on lookup type YES_NO).
ALWYS_SUM_ALL_CVG_FLAG_M	VARCHAR2	(4000)		Always sum all coverage (Lookup meaning based on lookup type YES_NO).
ALWYS_CNT_ALL_PRTTS_FLAG	VARCHAR2	(30)	Yes	Always count all participants (Lookup code based on lookup type YES_NO).
ALWYS_CNT_ALL_PRTTS_FLAG_M	VARCHAR2	(4000)		Always count all participants (Lookup meaning based on lookup type YES_NO).
RT_HRLY_SLRD_FLAG	VARCHAR2	(30)	Yes	Hourly salaried criteria (Lookup code based on lookup type YES_NO).
RT_HRLY_SLRD_FLAG_M	VARCHAR2	(4000)		Hourly salaried criteria (Lookup meaning based on lookup type YES_NO).
RT_PSTL_CD_FLAG	VARCHAR2	(30)	Yes	Postal code criteria (Lookup code based on lookup type YES_NO).
RT_PSTL_CD_FLAG_M	VARCHAR2	(4000)		Postal code criteria (Lookup meaning based on lookup type YES_NO).
RT_LBR_MMBR_FLAG	VARCHAR2	(30)	Yes	Labour member criteria (Lookup code based on lookup type YES_NO).
RT_LBR_MMBR_FLAG_M	VARCHAR2	(4000)		Labour member criteria (Lookup meaning based on lookup type YES_NO).
RT_LGL_ENTY_FLAG	VARCHAR2	(30)	Yes	Legal entity criteria (Lookup code based on lookup type YES_NO).
RT_LGL_ENTY_FLAG_M	VARCHAR2	(4000)		Legal entity criteria (Lookup meaning based on lookup type YES_NO).
RT_BENFTS_GRP_FLAG	VARCHAR2	(30)	Yes	Benefits group criteria (Lookup code based on lookup type YES_NO).
RT_BENFTS_GRP_FLAG_M	VARCHAR2	(4000)		Benefits group criteria (Lookup meaning based on lookup type YES_NO).
RT_WK_LOC_FLAG	VARCHAR2	(30)	Yes	Work location criteria (Lookup code based on lookup type YES_NO).
RT_WK_LOC_FLAG_M	VARCHAR2	(4000)		Work location criteria (Lookup meaning based on lookup type YES_NO).
RT_BRGNG_UNIT_FLAG	VARCHAR2	(30)	Yes	Bargaining unit criteria (Lookup code based on lookup type YES_NO).
RT_BRGNG_UNIT_FLAG_M	VARCHAR2	(4000)		Bargaining unit criteria (Lookup meaning based on lookup type YES_NO).
RT_AGE_FLAG	VARCHAR2	(30)	Yes	Age criteria (Lookup code based on lookup type YES_NO).
RT_AGE_FLAG_M	VARCHAR2	(4000)		Age criteria (Lookup meaning based on lookup type YES_NO).
RT_LOS_FLAG	VARCHAR2	(30)	Yes	Length of service criteria (Lookup code based on lookup type YES_NO).
RT_LOS_FLAG_M	VARCHAR2	(4000)		Length of service criteria (Lookup meaning based on lookup type YES_NO).
RT_PER_TYP_FLAG	VARCHAR2	(30)	Yes	Person type criteria (Lookup code based on lookup type YES_NO).
RT_PER_TYP_FLAG_M	VARCHAR2	(4000)		Person type criteria (Lookup meaning based on lookup type YES_NO).
RT_FL_TM_PT_TM_FLAG	VARCHAR2	(30)	Yes	Full time part time criteria (Lookup code based on lookup type YES_NO).
RT_FL_TM_PT_TM_FLAG_M	VARCHAR2	(4000)		Full time part time criteria (Lookup meaning based on lookup type YES_NO).
RT_EE_STAT_FLAG	VARCHAR2	(30)	Yes	Employee status criteria (Lookup code based on lookup type YES_NO).
RT_EE_STAT_FLAG_M	VARCHAR2	(4000)		Employee status criteria (Lookup meaning based on lookup type YES_NO).
RT_GRD_FLAG	VARCHAR2	(30)	Yes	Grade flag (Lookup code based on lookup type YES_NO).
RT_GRD_FLAG_M	VARCHAR2	(4000)		Grade flag (Lookup meaning based on lookup type YES_NO).
RT_PCT_FL_TM_FLAG	VARCHAR2	(30)	Yes	Percent full time criteria (Lookup code based on lookup type YES_NO).
RT_PCT_FL_TM_FLAG_M	VARCHAR2	(4000)		Percent full time criteria (Lookup meaning based on lookup type YES_NO).
RT_ASNT_SET_FLAG	VARCHAR2	(30)	Yes	Assignment set criteria (Lookup code based on lookup type YES_NO).
RT_ASNT_SET_FLAG_M	VARCHAR2	(4000)		Assignment set criteria (Lookup meaning based on lookup type YES_NO).
RT_HRS_WKD_FLAG	VARCHAR2	(30)	Yes	Hours worked criteria (Lookup code based on lookup type YES_NO).
RT_HRS_WKD_FLAG_M	VARCHAR2	(4000)		Hours worked criteria (Lookup meaning based on lookup type YES_NO).
RT_COMP_LVL_FLAG	VARCHAR2	(30)	Yes	Compensation level criteria (Lookup code based on lookup type YES_NO).
RT_COMP_LVL_FLAG_M	VARCHAR2	(4000)		Compensation level criteria (Lookup meaning based on lookup type YES_NO).
RT_ORG_UNIT_FLAG	VARCHAR2	(30)	Yes	Organisation unit criteria (Lookup code based on lookup type YES_NO).
RT_ORG_UNIT_FLAG_M	VARCHAR2	(4000)		Organisation unit criteria (Lookup meaning based on lookup type YES_NO).
RT_LOA_RSN_FLAG	VARCHAR2	(30)	Yes	Leave of absence criteria (Lookup code based on lookup type YES_NO).
RT_LOA_RSN_FLAG_M	VARCHAR2	(4000)		Leave of absence criteria (Lookup meaning based on lookup type YES_NO).
RT_PYRL_FLAG	VARCHAR2	(30)	Yes	Payroll criteria (Lookup code based on lookup type YES_NO).
RT_PYRL_FLAG_M	VARCHAR2	(4000)		Payroll criteria (Lookup meaning based on lookup type YES_NO).
RT_SCHEDD_HRS_FLAG	VARCHAR2	(30)	Yes	Scheduled hours criteria (Lookup code based on lookup type YES_NO).
RT_SCHEDD_HRS_FLAG_M	VARCHAR2	(4000)		Scheduled hours criteria (Lookup meaning based on lookup type YES_NO).
RT_PY_BSS_FLAG	VARCHAR2	(30)	Yes	Pay basis criteria (Lookup code based on lookup type YES_NO).
RT_PY_BSS_FLAG_M	VARCHAR2	(4000)		Pay basis criteria (Lookup meaning based on lookup type YES_NO).
RT_PRFL_RL_FLAG	VARCHAR2	(30)	Yes	Profile rule criteria (Lookup code based on lookup type YES_NO).
RT_PRFL_RL_FLAG_M	VARCHAR2	(4000)		Profile rule criteria (Lookup meaning based on lookup type YES_NO).
RT_CMBN_AGE_LOS_FLAG	VARCHAR2	(30)	Yes	Combination of age and length of service criteria (Lookup code based on lookup type YES_NO).
RT_CMBN_AGE_LOS_FLAG_M	VARCHAR2	(4000)		Combination of age and length of service criteria (Lookup meaning based on lookup type YES_NO).
RT_PRTT_PL_FLAG	VARCHAR2	(30)	Yes	Participant plan criteria (Lookup code based on lookup type YES_NO).
RT_PRTT_PL_FLAG_M	VARCHAR2	(4000)		Participant plan criteria (Lookup meaning based on lookup type YES_NO).
RT_SVC_AREA_FLAG	VARCHAR2	(30)	Yes	Service area criteria (Lookup code based on lookup type YES_NO).
RT_SVC_AREA_FLAG_M	VARCHAR2	(4000)		Service area criteria (Lookup meaning based on lookup type YES_NO).
RT_PPL_GRP_FLAG	VARCHAR2	(30)	Yes	People group criteria (Lookup code based on lookup type YES_NO).
RT_PPL_GRP_FLAG_M	VARCHAR2	(4000)		People group criteria (Lookup meaning based on lookup type YES_NO).
RT_DSBLD_FLAG	VARCHAR2	(30)	Yes	Disabled criteria (Lookup code based on lookup type YES_NO).
RT_DSBLD_FLAG_M	VARCHAR2	(4000)		Disabled criteria (Lookup meaning based on lookup type YES_NO).
RT_HLTH_CVG_FLAG	VARCHAR2	(30)	Yes	Health coverage criteria (Lookup code based on lookup type YES_NO).
RT_HLTH_CVG_FLAG_M	VARCHAR2	(4000)		Health coverage criteria (Lookup meaning based on lookup type YES_NO).
RT_POE_FLAG	VARCHAR2	(30)	Yes	Period of enrollment criteria (Lookup code based on lookup type YES_NO).
RT_POE_FLAG_M	VARCHAR2	(4000)		Period of enrollment criteria (Lookup meaning based on lookup type YES_NO).
RT_TTL_CVG_VOL_FLAG	VARCHAR2	(30)	Yes	Total coverage volume criteria (Lookup code based on lookup type YES_NO).
RT_TTL_CVG_VOL_FLAG_M	VARCHAR2	(4000)		Total coverage volume criteria (Lookup meaning based on lookup type YES_NO).
RT_TTL_PRTT_FLAG	VARCHAR2	(30)	Yes	Total participants criteria (Lookup code based on lookup type YES_NO).
RT_TTL_PRTT_FLAG_M	VARCHAR2	(4000)		Total participants criteria (Lookup meaning based on lookup type YES_NO).
RT_GNDR_FLAG	VARCHAR2	(30)	Yes	Gender criteria (Lookup code based on lookup type YES_NO).
RT_GNDR_FLAG_M	VARCHAR2	(4000)		Gender criteria (Lookup meaning based on lookup type YES_NO).
RT_TBCO_USE_FLAG	VARCHAR2	(30)	Yes	Tobacco usage criteria (Lookup code based on lookup type YES_NO).
RT_TBCO_USE_FLAG_M	VARCHAR2	(4000)		Tobacco usage criteria (Lookup meaning based on lookup type YES_NO).
RT_CNTNG_PRTN_PRFL_FLAG	VARCHAR2	(30)	Yes	Continuing participation profile criteria (Lookup code based on lookup type YES_NO).
RT_CNTNG_PRTN_PRFL_FLAG_M	VARCHAR2	(4000)		Continuing participation profile criteria (Lookup meaning based on lookup type YES_NO).
RT_CBR_QUALD_BNF_FLAG	VARCHAR2	(30)	Yes	Cobra qualified beneficiary criteria (Lookup code based on lookup type YES_NO).
RT_CBR_QUALD_BNF_FLAG_M	VARCHAR2	(4000)		Cobra qualified beneficiary criteria (Lookup meaning based on lookup type YES_NO).
RT_OPTD_MDCR_FLAG	VARCHAR2	(30)	Yes	Opted for medicare criteria (Lookup code based on lookup type YES_NO).
RT_OPTD_MDCR_FLAG_M	VARCHAR2	(4000)		Opted for medicare criteria (Lookup meaning based on lookup type YES_NO).
RT_LVG_RSN_FLAG	VARCHAR2	(30)	Yes	Leaving reason criteria (Lookup code based on lookup type YES_NO).
RT_LVG_RSN_FLAG_M	VARCHAR2	(4000)		Leaving reason criteria (Lookup meaning based on lookup type YES_NO).
RT_PSTN_FLAG	VARCHAR2	(30)	Yes	Position criteria (Lookup code based on lookup type YES_NO).
RT_PSTN_FLAG_M	VARCHAR2	(4000)		Position criteria (Lookup meaning based on lookup type YES_NO).
RT_COMPTNCY_FLAG	VARCHAR2	(30)	Yes	Competency criteria (Lookup code based on lookup type YES_NO).
RT_COMPTNCY_FLAG_M	VARCHAR2	(4000)		Competency criteria (Lookup meaning based on lookup type YES_NO).
RT_JOB_FLAG	VARCHAR2	(30)	Yes	Job criteria (Lookup code based on lookup type YES_NO).
RT_JOB_FLAG_M	VARCHAR2	(4000)		Job criteria (Lookup meaning based on lookup type YES_NO).
RT_DPNT_CVRD_PL_FLAG	VARCHAR2	(30)	Yes	Dependent covered in another plan criteria (Lookup code based on lookup type YES_NO).
RT_DPNT_CVRD_PL_FLAG_M	VARCHAR2	(4000)		Dependent covered in another plan criteria (Lookup meaning based on lookup type YES_NO).
RT_DPNT_CVRD_PLIP_FLAG	VARCHAR2	(30)	Yes	Dependent covered in another plan in program criteria (Lookup code based on lookup type YES_NO).
RT_DPNT_CVRD_PLIP_FLAG_M	VARCHAR2	(4000)		Dependent covered in another plan in program criteria (Lookup meaning based on lookup type YES_NO).
RT_DPNT_CVRD_PTIP_FLAG	VARCHAR2	(30)	Yes	Dependent covered in another plan type in program criteria (Lookup code based on lookup type YES_NO).
RT_DPNT_CVRD_PTIP_FLAG_M	VARCHAR2	(4000)		Dependent covered in another plan type in program criteria (Lookup meaning based on lookup type YES_NO).
RT_DPNT_CVRD_PGM_FLAG	VARCHAR2	(30)	Yes	Dependent covered in another program criteria (Lookup code based on lookup type YES_NO).
RT_DPNT_CVRD_PGM_FLAG_M	VARCHAR2	(4000)		Dependent covered in another program criteria (Lookup meaning based on lookup type YES_NO).
RT_ENRLD_OIPL_FLAG	VARCHAR2	(30)	Yes	Dependent covered in another option in plan criteria (Lookup code based on lookup type YES_NO).
RT_ENRLD_OIPL_FLAG_M	VARCHAR2	(4000)		Dependent covered in another option in plan criteria (Lookup meaning based on lookup type YES_NO).
RT_ENRLD_PL_FLAG	VARCHAR2	(30)	Yes	Enrolled in another plan criteria (Lookup code based on lookup type YES_NO).
RT_ENRLD_PL_FLAG_M	VARCHAR2	(4000)		Enrolled in another plan criteria (Lookup meaning based on lookup type YES_NO).
RT_ENRLD_PLIP_FLAG	VARCHAR2	(30)	Yes	Enrolled in another plan in program criteria (Lookup code based on lookup type YES_NO).
RT_ENRLD_PLIP_FLAG_M	VARCHAR2	(4000)		Enrolled in another plan in program criteria (Lookup meaning based on lookup type YES_NO).
RT_ENRLD_PTIP_FLAG	VARCHAR2	(30)	Yes	Enrolled in another plan type in program criteria (Lookup code based on lookup type YES_NO).
RT_ENRLD_PTIP_FLAG_M	VARCHAR2	(4000)		Enrolled in another plan type in program criteria (Lookup meaning based on lookup type YES_NO).
RT_ENRLD_PGM_FLAG	VARCHAR2	(30)	Yes	Enrolled in another program criteria (Lookup code based on lookup type YES_NO).
RT_ENRLD_PGM_FLAG_M	VARCHAR2	(4000)		Enrolled in another program criteria (Lookup meaning based on lookup type YES_NO).
RT_PRTT_ANTHR_PL_FLAG	VARCHAR2	(30)	Yes	Participant eligible for another plan criteria (Lookup code based on lookup type YES_NO).
RT_PRTT_ANTHR_PL_FLAG_M	VARCHAR2	(4000)		Participant eligible for another plan criteria (Lookup meaning based on lookup type YES_NO).
RT_OTHR_PTIP_FLAG	VARCHAR2	(30)	Yes	Eligible for another plan type in program criteria (Lookup code based on lookup type YES_NO).
RT_OTHR_PTIP_FLAG_M	VARCHAR2	(4000)		Eligible for another plan type in program criteria (Lookup meaning based on lookup type YES_NO).
RT_NO_OTHR_CVG_FLAG	VARCHAR2	(30)	Yes	No other coverage criteria (Lookup code based on lookup type YES_NO).
RT_NO_OTHR_CVG_FLAG_M	VARCHAR2	(4000)		No other coverage criteria (Lookup meaning based on lookup type YES_NO).
RT_DPNT_OTHR_PTIP_FLAG	VARCHAR2	(30)	Yes	Dependent eligible for another plan type in program criteria (Lookup code based on lookup type YES_NO).
RT_DPNT_OTHR_PTIP_FLAG_M	VARCHAR2	(4000)		Dependent eligible for another plan type in program criteria (Lookup meaning based on lookup type YES_NO).
RT_QUAL_TITL_FLAG	VARCHAR2	(30)	Yes	Qualification title criteria (Lookup code based on lookup type YES_NO).
RT_QUAL_TITL_FLAG_M	VARCHAR2	(4000)		Qualification title criteria (Lookup meaning based on lookup type YES_NO).
RT_PERF_RTNG_FLAG	VARCHAR2	(30)	Yes	Performance rating criteria (Lookup code based on lookup type YES_NO).
RT_PERF_RTNG_FLAG_M	VARCHAR2	(4000)		Performance rating criteria (Lookup meaning based on lookup type YES_NO).
RT_QUA_IN_GR_FLAG	VARCHAR2	(30)	Yes	Quartile in grade criteria (Lookup code based on lookup type YES_NO).
RT_QUA_IN_GR_FLAG_M	VARCHAR2	(4000)		Quartile in grade criteria (Lookup meaning based on lookup type YES_NO).
RT_ELIG_PRFL_FLAG	VARCHAR2	(30)	Yes	Rate Eligibility Profile Flag(Lookup meaning based on lookup type YES_NO).
RT_ELIG_PRFL_FLAG_M	VARCHAR2	(4000)		Rate Eligibility Profile Flag(Lookup meaning based on lookup type YES_NO).
VRBL_RT_PRFL_ID	NUMBER	(15)	Yes	System generated primary key column.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign Key to HR_ORGANIZATION_UNITS.
OIPL_ID	NUMBER	(15)		Foreign key to BEN_OIPL_F.
PL_ID	NUMBER	(15)		Foreign key to BEN_PL_F.
PL_TYP_OPT_TYP_ID	NUMBER	(15)		Foreign key to BEN_PL_TYP_OPT_TYP_F.
COMP_LVL_FCTR_ID	NUMBER	(15)		Foreign key to BEN_COMP_LVL_FCTR.
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
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.

Query Text

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


SELECT EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      NAME
,      INCRMNT_ELCN_VAL
,      DFLT_ELCN_VAL
,      MX_ELCN_VAL
,      MN_ELCN_VAL
,      VAL
,      VAL_CALC_RL
,      RNDG_RL
,      LWR_LMT_VAL
,      LWR_LMT_CALC_RL
,      UPR_LMT_VAL
,      UPR_LMT_CALC_RL
,      ANN_MN_ELCN_VAL
,      ANN_MX_ELCN_VAL
,      ULTMT_UPR_LMT
,      ULTMT_LWR_LMT
,      ULTMT_UPR_LMT_CALC_RL
,      ULTMT_LWR_LMT_CALC_RL
,      _DF:VPF
,      TX_TYP_CD
,      TX_TYP_CD_M
,      VRBL_RT_TRTMT_CD
,      VRBL_RT_TRTMT_CD_M
,      ACTY_REF_PERD_CD
,      ACTY_REF_PERD_CD_M
,      MLT_CD
,      MLT_CD_M
,      ASMT_TO_USE_CD
,      ASMT_TO_USE_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
,      VRBL_RT_PRFL_STAT_CD
,      VRBL_RT_PRFL_STAT_CD_M
,      VRBL_USG_CD
,      VRBL_USG_CD_M
,      RNDG_CD
,      RNDG_CD_M
,      NO_MN_ELCN_VAL_DFND_FLAG
,      NO_MN_ELCN_VAL_DFND_FLAG_M
,      NO_MX_ELCN_VAL_DFND_FLAG
,      NO_MX_ELCN_VAL_DFND_FLAG_M
,      ALWYS_SUM_ALL_CVG_FLAG
,      ALWYS_SUM_ALL_CVG_FLAG_M
,      ALWYS_CNT_ALL_PRTTS_FLAG
,      ALWYS_CNT_ALL_PRTTS_FLAG_M
,      RT_HRLY_SLRD_FLAG
,      RT_HRLY_SLRD_FLAG_M
,      RT_PSTL_CD_FLAG
,      RT_PSTL_CD_FLAG_M
,      RT_LBR_MMBR_FLAG
,      RT_LBR_MMBR_FLAG_M
,      RT_LGL_ENTY_FLAG
,      RT_LGL_ENTY_FLAG_M
,      RT_BENFTS_GRP_FLAG
,      RT_BENFTS_GRP_FLAG_M
,      RT_WK_LOC_FLAG
,      RT_WK_LOC_FLAG_M
,      RT_BRGNG_UNIT_FLAG
,      RT_BRGNG_UNIT_FLAG_M
,      RT_AGE_FLAG
,      RT_AGE_FLAG_M
,      RT_LOS_FLAG
,      RT_LOS_FLAG_M
,      RT_PER_TYP_FLAG
,      RT_PER_TYP_FLAG_M
,      RT_FL_TM_PT_TM_FLAG
,      RT_FL_TM_PT_TM_FLAG_M
,      RT_EE_STAT_FLAG
,      RT_EE_STAT_FLAG_M
,      RT_GRD_FLAG
,      RT_GRD_FLAG_M
,      RT_PCT_FL_TM_FLAG
,      RT_PCT_FL_TM_FLAG_M
,      RT_ASNT_SET_FLAG
,      RT_ASNT_SET_FLAG_M
,      RT_HRS_WKD_FLAG
,      RT_HRS_WKD_FLAG_M
,      RT_COMP_LVL_FLAG
,      RT_COMP_LVL_FLAG_M
,      RT_ORG_UNIT_FLAG
,      RT_ORG_UNIT_FLAG_M
,      RT_LOA_RSN_FLAG
,      RT_LOA_RSN_FLAG_M
,      RT_PYRL_FLAG
,      RT_PYRL_FLAG_M
,      RT_SCHEDD_HRS_FLAG
,      RT_SCHEDD_HRS_FLAG_M
,      RT_PY_BSS_FLAG
,      RT_PY_BSS_FLAG_M
,      RT_PRFL_RL_FLAG
,      RT_PRFL_RL_FLAG_M
,      RT_CMBN_AGE_LOS_FLAG
,      RT_CMBN_AGE_LOS_FLAG_M
,      RT_PRTT_PL_FLAG
,      RT_PRTT_PL_FLAG_M
,      RT_SVC_AREA_FLAG
,      RT_SVC_AREA_FLAG_M
,      RT_PPL_GRP_FLAG
,      RT_PPL_GRP_FLAG_M
,      RT_DSBLD_FLAG
,      RT_DSBLD_FLAG_M
,      RT_HLTH_CVG_FLAG
,      RT_HLTH_CVG_FLAG_M
,      RT_POE_FLAG
,      RT_POE_FLAG_M
,      RT_TTL_CVG_VOL_FLAG
,      RT_TTL_CVG_VOL_FLAG_M
,      RT_TTL_PRTT_FLAG
,      RT_TTL_PRTT_FLAG_M
,      RT_GNDR_FLAG
,      RT_GNDR_FLAG_M
,      RT_TBCO_USE_FLAG
,      RT_TBCO_USE_FLAG_M
,      RT_CNTNG_PRTN_PRFL_FLAG
,      RT_CNTNG_PRTN_PRFL_FLAG_M
,      RT_CBR_QUALD_BNF_FLAG
,      RT_CBR_QUALD_BNF_FLAG_M
,      RT_OPTD_MDCR_FLAG
,      RT_OPTD_MDCR_FLAG_M
,      RT_LVG_RSN_FLAG
,      RT_LVG_RSN_FLAG_M
,      RT_PSTN_FLAG
,      RT_PSTN_FLAG_M
,      RT_COMPTNCY_FLAG
,      RT_COMPTNCY_FLAG_M
,      RT_JOB_FLAG
,      RT_JOB_FLAG_M
,      RT_DPNT_CVRD_PL_FLAG
,      RT_DPNT_CVRD_PL_FLAG_M
,      RT_DPNT_CVRD_PLIP_FLAG
,      RT_DPNT_CVRD_PLIP_FLAG_M
,      RT_DPNT_CVRD_PTIP_FLAG
,      RT_DPNT_CVRD_PTIP_FLAG_M
,      RT_DPNT_CVRD_PGM_FLAG
,      RT_DPNT_CVRD_PGM_FLAG_M
,      RT_ENRLD_OIPL_FLAG
,      RT_ENRLD_OIPL_FLAG_M
,      RT_ENRLD_PL_FLAG
,      RT_ENRLD_PL_FLAG_M
,      RT_ENRLD_PLIP_FLAG
,      RT_ENRLD_PLIP_FLAG_M
,      RT_ENRLD_PTIP_FLAG
,      RT_ENRLD_PTIP_FLAG_M
,      RT_ENRLD_PGM_FLAG
,      RT_ENRLD_PGM_FLAG_M
,      RT_PRTT_ANTHR_PL_FLAG
,      RT_PRTT_ANTHR_PL_FLAG_M
,      RT_OTHR_PTIP_FLAG
,      RT_OTHR_PTIP_FLAG_M
,      RT_NO_OTHR_CVG_FLAG
,      RT_NO_OTHR_CVG_FLAG_M
,      RT_DPNT_OTHR_PTIP_FLAG
,      RT_DPNT_OTHR_PTIP_FLAG_M
,      RT_QUAL_TITL_FLAG
,      RT_QUAL_TITL_FLAG_M
,      RT_PERF_RTNG_FLAG
,      RT_PERF_RTNG_FLAG_M
,      RT_QUA_IN_GR_FLAG
,      RT_QUA_IN_GR_FLAG_M
,      RT_ELIG_PRFL_FLAG
,      RT_ELIG_PRFL_FLAG_M
,      VRBL_RT_PRFL_ID
,      BUSINESS_GROUP_ID
,      OIPL_ID
,      PL_ID
,      PL_TYP_OPT_TYP_ID
,      COMP_LVL_FCTR_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.BENBV_VRBL_RT_PRFL_V;

Dependencies

[top of page]

APPS.BENBV_VRBL_RT_PRFL_V references the following:

APPS: BEN_VRBL_RT_PRFL_F; HR_BIS - show dependent code

APPS.BENBV_VRBL_RT_PRFL_V is not referenced by any database object