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

VIEW: APPS.BEN_ELCTBL_CHC_ENRT_RT_V

Object Details
Object Name: BEN_ELCTBL_CHC_ENRT_RT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BEN_ELCTBL_CHC_ENRT_RT_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
NAME VARCHAR2 (240) Yes
ELIG_PER_ELCTBL_CHC_ID_EPE NUMBER (15) Yes
CRNTLY_ENRD_FLAG VARCHAR2 (30) Yes
DFLT_FLAG_EPE VARCHAR2 (30) Yes
ELCTBL_FLAG VARCHAR2 (30) Yes
PL_ID NUMBER (15)
Foreign Key to BEN_PL_F.
OIPL_ID NUMBER (15)
Foreign Key to BEN_OIPL_F.
PER_IN_LER_ID NUMBER (15) Yes Foreign Key to BEN_PER_IN_LER.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign Key to HR_ORGANIZATION_UNITS
ENRT_RT_ID NUMBER (15)

ACTY_TYP_CD VARCHAR2 (30)

TX_TYP_CD VARCHAR2 (30)

CTFN_RQD_FLAG VARCHAR2 (30)

DSPLY_ON_ENRT_FLAG VARCHAR2 (30)

ENTR_VAL_AT_ENRT_FLAG VARCHAR2 (30)

VAL NUMBER


MX_ELCN_VAL NUMBER


MN_ELCN_VAL NUMBER


INCRMT_ELCN_VAL NUMBER


OIPL_ORDR_NUM NUMBER (15)

Query Text

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


SELECT NAME
,      ELIG_PER_ELCTBL_CHC_ID_EPE
,      CRNTLY_ENRD_FLAG
,      DFLT_FLAG_EPE
,      ELCTBL_FLAG
,      PL_ID
,      OIPL_ID
,      PER_IN_LER_ID
,      BUSINESS_GROUP_ID
,      ENRT_RT_ID
,      ACTY_TYP_CD
,      TX_TYP_CD
,      CTFN_RQD_FLAG
,      DSPLY_ON_ENRT_FLAG
,      ENTR_VAL_AT_ENRT_FLAG
,      VAL
,      MX_ELCN_VAL
,      MN_ELCN_VAL
,      INCRMT_ELCN_VAL
,      OIPL_ORDR_NUM
FROM APPS.BEN_ELCTBL_CHC_ENRT_RT_V;

Dependencies

[top of page]

APPS.BEN_ELCTBL_CHC_ENRT_RT_V references the following:

SchemaAPPS
SynonymBEN_ELIG_PER_ELCTBL_CHC
SynonymBEN_ENRT_RT
SynonymBEN_OIPL_F
SynonymBEN_OPT_F
SynonymBEN_PER_IN_LER
SynonymFND_SESSIONS

APPS.BEN_ELCTBL_CHC_ENRT_RT_V is not referenced by any database object