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

VIEW: APPS.BEN_PRMRY_CARE_PRVDR_PEN_V

Object Details
Object Name: BEN_PRMRY_CARE_PRVDR_PEN_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BEN_PRMRY_CARE_PRVDR_PEN_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
PERSON_ID NUMBER (15)
Foreign Key to PER_PEOPLE_F.
PRTT_ENRT_RSLT_ID NUMBER

ELIG_CVRD_DPNT_ID NUMBER

PL_TYP_ID NUMBER (15)
PL_ID NUMBER (15)
Foreign Key to BEN_PL_F.
BUSINESS_GROUP_ID NUMBER (15)
Foreign Key to HR_ORGANIZATION_UNITS
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated primary key. Increments by one each update.
EFFECTIVE_START_DATE DATE

Effective start date.
EFFECTIVE_END_DATE DATE

Effective end date.
LER_ID NUMBER (15)
Foreign Key to BEN_LER_F.
PTIP_ID NUMBER (15)
Foreign Key to BEN_PTIP_F.
OIPL_ID NUMBER (15)
Foreign Key to BEN_OIPL_F.
Query Text

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


SELECT PERSON_ID
,      PRTT_ENRT_RSLT_ID
,      ELIG_CVRD_DPNT_ID
,      PL_TYP_ID
,      PL_ID
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      LER_ID
,      PTIP_ID
,      OIPL_ID
FROM APPS.BEN_PRMRY_CARE_PRVDR_PEN_V;

Dependencies

[top of page]

APPS.BEN_PRMRY_CARE_PRVDR_PEN_V references the following:

SchemaAPPS
SynonymBEN_ELIG_CVRD_DPNT_F
SynonymBEN_PER_IN_LER
SynonymBEN_PRMRY_CARE_PRVDR_F
SynonymBEN_PRTT_ENRT_RSLT_F
SynonymFND_SESSIONS

APPS.BEN_PRMRY_CARE_PRVDR_PEN_V is not referenced by any database object