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.BEN_ENRT_MISC_LOV_INFO_LE_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PL_TYP_ID	NUMBER	(15)		Plan Type Id
PL_TYP_ID_NAME	VARCHAR2	(240)	Yes	Plan Type Name
PL_ID	NUMBER	(15)		Plan Id
PL_ID_NAME	VARCHAR2	(240)	Yes	Plan Name
OPT_ID	NUMBER	(15)		Option Id
OPT_NAME	VARCHAR2	(240)		Option Name
OIPL_ID	NUMBER	(15)		Oipl Id
BNFT_VAL	NUMBER			Benefit Amount
BNFT_NNMNTRY_UOM	VARCHAR2	(30)		Unit of Measure
INCRMT_VAL	NUMBER			Increment Value
BNFT_TYP_CD	VARCHAR2	(30)		Benefit Type Code
CVG_MLT_CD	VARCHAR2	(30)		Coverage Multiplier Code
ENTR_VAL_AT_ENRT_FLAG	VARCHAR2	(30)		Enter Benefit Amount at Enrollment
ENRT_CVG_STRT_DT_CD	VARCHAR2	(30)		Coverage Start Code
CRNTLY_ENRD_FLAG	VARCHAR2	(30)	Yes	Currently enrolled Flag
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business Group Id
MNDTRY_FLAG	VARCHAR2	(30)	Yes	Mandatory Flag
DFLT_FLAG	VARCHAR2	(30)	Yes	Default Flag
ELIG_PER_ELCTBL_CHC_ID	NUMBER	(15)	Yes	Foreign key to ben_elig_per_elctbl_chc
PER_IN_LER_ID	NUMBER	(15)	Yes	Foriegn key to ben_per_in_ler
LF_EVT_OCRD_DT	DATE		Yes	Life Event Occured Date
CHOICE_OVN	NUMBER	(9)		EPE Object version number
PRTT_ENRT_RSLT_ID	NUMBER	(15)		EPE Result Id
ENRT_BNFT_ID	NUMBER	(15)		Benefit Id
ENRT_CVG_STRT_DT	DATE			EPE Coverage Start Date
ERLST_DEENRT_DT	DATE			Earliest Deenrollement Date
PERSON_ID	NUMBER	(15)	Yes	Person Id
CTFN_RQD_FLAG	VARCHAR2	(30)		Cerification Required Flag
UOM	VARCHAR2	(30)		Unit Of Measure
ACTY_REF_PERD_CD	VARCHAR2	(30)		Activity Reference Period
CLS_ENRT_DT_TO_USE_CD	VARCHAR2	(30)		Close Enrollment Date To Use Code
PL_ORDR_NUM	NUMBER	(15)		Sequence Number of the Plan
PLIP_ORDR_NUM	NUMBER	(15)		Sequence Number of the Plan in Program
PTIP_ORDR_NUM	NUMBER	(15)		Sequence Number of the Plan Type in Program
OIPL_ORDR_NUM	NUMBER	(15)		Sequence Number of the Option in Plan
PEN_PRTT_ENRT_RSLT_ID	NUMBER	(15)		PEN Result Id
PEN_ENRT_CVG_STRT_DT	DATE			PEN Coverage Start Date
PEN_ENRT_CVG_THRU_DT	DATE			PEN Coverage End Date
PEN_ENRT_SSPNDD_FLAG	VARCHAR2	(30)		Suspended Flag
PEN_RPLCS_SSPNDD_RSLT_ID	NUMBER	(15)		Suspended Result Id
MN_VAL	NUMBER			Min Benefit Amount
MX_VAL	NUMBER			Max Benefit Amount
MX_WOUT_CTFN_VAL	NUMBER			Max Amount without Certification
IN_PNDG_WKFLOW_FLAG_MEANING	VARCHAR2	(1)		Workflow usage
IN_PNDG_WKFLOW_FLAG	VARCHAR2	(30)		Workflow usage

Query Text

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


SELECT PL_TYP_ID
,      PL_TYP_ID_NAME
,      PL_ID
,      PL_ID_NAME
,      OPT_ID
,      OPT_NAME
,      OIPL_ID
,      BNFT_VAL
,      BNFT_NNMNTRY_UOM
,      INCRMT_VAL
,      BNFT_TYP_CD
,      CVG_MLT_CD
,      ENTR_VAL_AT_ENRT_FLAG
,      ENRT_CVG_STRT_DT_CD
,      CRNTLY_ENRD_FLAG
,      BUSINESS_GROUP_ID
,      MNDTRY_FLAG
,      DFLT_FLAG
,      ELIG_PER_ELCTBL_CHC_ID
,      PER_IN_LER_ID
,      LF_EVT_OCRD_DT
,      CHOICE_OVN
,      PRTT_ENRT_RSLT_ID
,      ENRT_BNFT_ID
,      ENRT_CVG_STRT_DT
,      ERLST_DEENRT_DT
,      PERSON_ID
,      CTFN_RQD_FLAG
,      UOM
,      ACTY_REF_PERD_CD
,      CLS_ENRT_DT_TO_USE_CD
,      PL_ORDR_NUM
,      PLIP_ORDR_NUM
,      PTIP_ORDR_NUM
,      OIPL_ORDR_NUM
,      PEN_PRTT_ENRT_RSLT_ID
,      PEN_ENRT_CVG_STRT_DT
,      PEN_ENRT_CVG_THRU_DT
,      PEN_ENRT_SSPNDD_FLAG
,      PEN_RPLCS_SSPNDD_RSLT_ID
,      MN_VAL
,      MX_VAL
,      MX_WOUT_CTFN_VAL
,      IN_PNDG_WKFLOW_FLAG_MEANING
,      IN_PNDG_WKFLOW_FLAG
FROM APPS.BEN_ENRT_MISC_LOV_INFO_LE_V;

Dependencies

[top of page]

APPS.BEN_ENRT_MISC_LOV_INFO_LE_V references the following:

APPS: BEN_ELIG_PER_ELCTBL_CHC; BEN_ENRT_BNFT; BEN_LER_F; BEN_OIPL_F; BEN_OPT_F; BEN_PER_IN_LER; BEN_PIL_ELCTBL_CHC_POPL; BEN_PLIP_F; BEN_PL_F; BEN_PL_TYP_F; BEN_PRTT_ENRT_RSLT_F; FND_SESSIONS

APPS.BEN_ENRT_MISC_LOV_INFO_LE_V is referenced by following:

PUBLIC: BEN_ENRT_MISC_LOV_INFO_LE_V