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

VIEW: APPS.BEN_FLX_ENRT_POOL_LE_V

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

PL_TYP_NAME VARCHAR2 (240)
PL_NAME VARCHAR2 (240)
OPT_NAME VARCHAR2 (240)
PL_OPT_NAME VARCHAR2 (481)
CMBN_NAME VARCHAR2 (240)
POOL_NAME VARCHAR2 (240)
PGM_ID NUMBER (15)
CMBN_PLIP_ID NUMBER (15)
CMBN_PTIP_ID NUMBER (15)
CMBN_PTIP_OPT_ID NUMBER (15)
PL_ID NUMBER

PL_TYP_ID NUMBER

PTIP_ID NUMBER

PLIP_ID NUMBER

OIPL_ID NUMBER

PER_IN_LER_ID NUMBER (15)
PERSON_ID NUMBER (15)
LER_ID NUMBER (15)
BUSINESS_GROUP_ID NUMBER (15)
BNFT_PRVDR_POOL_ID NUMBER (15)
Query Text

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


SELECT VAL
,      PL_TYP_NAME
,      PL_NAME
,      OPT_NAME
,      PL_OPT_NAME
,      CMBN_NAME
,      POOL_NAME
,      PGM_ID
,      CMBN_PLIP_ID
,      CMBN_PTIP_ID
,      CMBN_PTIP_OPT_ID
,      PL_ID
,      PL_TYP_ID
,      PTIP_ID
,      PLIP_ID
,      OIPL_ID
,      PER_IN_LER_ID
,      PERSON_ID
,      LER_ID
,      BUSINESS_GROUP_ID
,      BNFT_PRVDR_POOL_ID
FROM APPS.BEN_FLX_ENRT_POOL_LE_V;

Dependencies

[top of page]

APPS.BEN_FLX_ENRT_POOL_LE_V references the following:

SchemaAPPS
SynonymBEN_BNFT_PRVDR_POOL_F
SynonymBEN_CMBN_PLIP_F
SynonymBEN_CMBN_PTIP_F
SynonymBEN_CMBN_PTIP_OPT_F
SynonymBEN_ELIG_PER_ELCTBL_CHC
SynonymBEN_ENRT_RT
SynonymBEN_OIPL_F
SynonymBEN_OPT_F
SynonymBEN_PER_IN_LER
SynonymBEN_PL_F
SynonymBEN_PL_TYP_F

APPS.BEN_FLX_ENRT_POOL_LE_V is not referenced by any database object