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

VIEW: APPS.BEN_ENRT_USED_INFO_V

Object Details
Object Name: BEN_ENRT_USED_INFO_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BEN_ENRT_USED_INFO_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)

PL_ID NUMBER (15)
Foreign Key to BEN_PL_F.
OIPL_ID NUMBER (15)
Foreign Key to BEN_OIPL_F.
PGM_ID NUMBER (15)

PTIP_ID NUMBER (15)
Foreign Key to BEN_PTIP_F.
PLIP_ID NUMBER (15)

BNFT_VAL NUMBER


PRE_TAX_VAL NUMBER


AFTR_TAX_VAL NUMBER


NET_VAL NUMBER


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.
PRTT_ENRT_RSLT_ID NUMBER (15)

PRE_TAX_RT_ID NUMBER


AFTR_TAX_RT_ID NUMBER


PRE_TAX_RT_POOL_ID NUMBER


AFTR_TAX_RT_POOL_ID NUMBER


ENRT_BNFT_ID NUMBER (15)

BUSINESS_GROUP_ID NUMBER (15) Yes Foreign Key to HR_ORGANIZATION_UNITS
MYROW NUMBER


Query Text

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


SELECT PL_TYP_ID
,      PL_ID
,      OIPL_ID
,      PGM_ID
,      PTIP_ID
,      PLIP_ID
,      BNFT_VAL
,      PRE_TAX_VAL
,      AFTR_TAX_VAL
,      NET_VAL
,      DFLT_FLAG
,      ELIG_PER_ELCTBL_CHC_ID
,      PER_IN_LER_ID
,      PRTT_ENRT_RSLT_ID
,      PRE_TAX_RT_ID
,      AFTR_TAX_RT_ID
,      PRE_TAX_RT_POOL_ID
,      AFTR_TAX_RT_POOL_ID
,      ENRT_BNFT_ID
,      BUSINESS_GROUP_ID
,      MYROW
FROM APPS.BEN_ENRT_USED_INFO_V;

Dependencies

[top of page]

APPS.BEN_ENRT_USED_INFO_V references the following:

SchemaAPPS
SynonymBEN_ELIG_PER_ELCTBL_CHC
SynonymBEN_ENRT_BNFT
SynonymBEN_ENRT_RT
SynonymBEN_PER_IN_LER

APPS.BEN_ENRT_USED_INFO_V is not referenced by any database object