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

VIEW: APPS.BEN_WFREP_ELCTBL_CHC_INFO_VW

Object Details
Object Name: BEN_WFREP_ELCTBL_CHC_INFO_VW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BEN_WFREP_ELCTBL_CHC_INFO_VW
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
ORDR_NUM NUMBER

BENEFIT_ACTION_ID NUMBER (15)
PERSON_ID NUMBER (15)
Foreign Key to PER_PEOPLE_F.
PGM_NAME VARCHAR2 (240)
PL_NAME VARCHAR2 (240)
OPT_NAME VARCHAR2 (240)
ENRT_CVG_STRT_DT DATE

ENRT_PERD_STRT_DT DATE

ENRT_PERD_END_DT DATE

ERLST_DEENRT_DT DATE

DFLT_ENRT_DT DATE

ENRT_TYP_CYCL_CD_NAME VARCHAR2 (4000)
COMP_LVL_CD_NAME VARCHAR2 (4000)
MNDTRY_FLAG VARCHAR2 (30)
DFLT_FLAG VARCHAR2 (30)
ELECTABLE_CHOICE_NAME VARCHAR2 (726)
Query Text

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


SELECT ORDR_NUM
,      BENEFIT_ACTION_ID
,      PERSON_ID
,      PGM_NAME
,      PL_NAME
,      OPT_NAME
,      ENRT_CVG_STRT_DT
,      ENRT_PERD_STRT_DT
,      ENRT_PERD_END_DT
,      ERLST_DEENRT_DT
,      DFLT_ENRT_DT
,      ENRT_TYP_CYCL_CD_NAME
,      COMP_LVL_CD_NAME
,      MNDTRY_FLAG
,      DFLT_FLAG
,      ELECTABLE_CHOICE_NAME
FROM APPS.BEN_WFREP_ELCTBL_CHC_INFO_VW;

Dependencies

[top of page]

APPS.BEN_WFREP_ELCTBL_CHC_INFO_VW references the following:

SchemaAPPS
SynonymBEN_BATCH_ELCTBL_CHC_INFO
SynonymBEN_BENEFIT_ACTIONS
SynonymBEN_OIPL_F
SynonymBEN_OPT_F
SynonymBEN_PGM_F
SynonymBEN_PL_F
PL/SQL PackageHR_GENERAL - show dependent code
APPS.BEN_WFREP_ELCTBL_CHC_INFO_VW is referenced by following:

SchemaPUBLIC
SynonymBEN_WFREP_ELCTBL_CHC_INFO_VW