[Home] [Help] [Dependency Information]
Object Name: | BEN_ENRT_MISC_LOV_INFO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BEN.BEN_ENRT_MISC_LOV_INFO_V |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PL_TYP_ID | NUMBER | (15) | ||
PL_TYP_ID_NAME | VARCHAR2 | (240) | Yes | |
PL_ID | NUMBER | (15) | Foreign Key to BEN_PL_F. | |
PL_ID_NAME | VARCHAR2 | (240) | Yes | |
OPT_ID | NUMBER | (15) | Foreign Key to BEN_OPT_F. | |
OPT_NAME | VARCHAR2 | (240) | ||
OIPL_ID | NUMBER | (15) | Foreign Key to BEN_OIPL_F. | |
BNFT_VAL | NUMBER | |||
BNFT_NNMNTRY_UOM | VARCHAR2 | (30) | ||
INCRMT_VAL | NUMBER | |||
BNFT_TYP_CD | VARCHAR2 | (30) | ||
CVG_MLT_CD | VARCHAR2 | (30) | ||
ENTR_VAL_AT_ENRT_FLAG | VARCHAR2 | (30) | ||
ENRT_CVG_STRT_DT_CD | VARCHAR2 | (30) | ||
CRNTLY_ENRD_FLAG | VARCHAR2 | (30) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
MNDTRY_FLAG | VARCHAR2 | (30) | Yes | |
DFLT_FLAG | VARCHAR2 | (30) | Yes | |
ELIG_PER_ELCTBL_CHC_ID | NUMBER | (15) | Yes | |
PER_IN_LER_ID | NUMBER | (15) | Yes | Foreign Key to BEN_PER_IN_LER. |
LF_EVT_OCRD_DT | DATE | Yes | Life event occured date | |
CHOICE_OVN | NUMBER | (9) | ||
PRTT_ENRT_RSLT_ID | NUMBER | (15) | ||
ENRT_BNFT_ID | NUMBER | (15) | ||
ENRT_CVG_STRT_DT | DATE | |||
ERLST_DEENRT_DT | DATE | |||
PERSON_ID | NUMBER | (15) | Yes | Foreign Key to PER_PEOPLE_F. |
CTFN_RQD_FLAG | VARCHAR2 | (30) | ||
UOM | VARCHAR2 | (30) | ||
ACTY_REF_PERD_CD | VARCHAR2 | (30) | ||
CLS_ENRT_DT_TO_USE_CD | VARCHAR2 | (30) | ||
PL_ORDR_NUM | NUMBER | (15) | ||
PLIP_ORDR_NUM | NUMBER | (15) | ||
PTIP_ORDR_NUM | NUMBER | (15) | ||
OIPL_ORDR_NUM | NUMBER | (15) | ||
PEN_PRTT_ENRT_RSLT_ID | NUMBER | (15) | ||
PEN_ENRT_CVG_STRT_DT | DATE | |||
PEN_ENRT_CVG_THRU_DT | DATE | |||
PEN_ENRT_SSPNDD_FLAG | VARCHAR2 | (30) | ||
PEN_RPLCS_SSPNDD_RSLT_ID | NUMBER | (15) | ||
MN_VAL | NUMBER | |||
MX_VAL | NUMBER | |||
MX_WOUT_CTFN_VAL | NUMBER | |||
IN_PNDG_WKFLOW_FLAG_MEANING | VARCHAR2 | (1) | ||
IN_PNDG_WKFLOW_FLAG | VARCHAR2 | (30) |
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_V;
APPS.BEN_ENRT_MISC_LOV_INFO_V is not referenced by any database object
|
|
|