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

VIEW: APPS.BEN_PRTT_ENRT_RSLT_V

Object Details
Object Name: BEN_PRTT_ENRT_RSLT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BEN_PRTT_ENRT_RSLT_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
ROW_ID ROWID (10)

PRTT_ENRT_RSLT_ID NUMBER (15) Yes
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign Key to HR_ORGANIZATION_UNITS
OIPL_ID NUMBER (15)
Foreign Key to BEN_OIPL_F.
PERSON_ID NUMBER (15) Yes Foreign Key to PER_PEOPLE_F.
ASSIGNMENT_ID NUMBER (15)

PGM_ID NUMBER (15)

PGM_NAME VARCHAR2 (240)

PL_ID NUMBER (15) Yes Foreign Key to BEN_PL_F.
RPLCS_SSPNDD_RSLT_ID NUMBER (15)

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

LER_ID NUMBER (15) Yes Foreign Key to BEN_LER_F.
SSPNDD_FLAG VARCHAR2 (30) Yes
PRTT_IS_CVRD_FLAG VARCHAR2 (30) Yes
BNFT_AMT NUMBER


UOM VARCHAR2 (30)

ORGNL_ENRT_DT DATE


ENRT_MTHD_CD VARCHAR2 (30) Yes
NO_LNGR_ELIG_FLAG VARCHAR2 (30) Yes
ENRT_OVRIDN_FLAG VARCHAR2 (30) Yes
ENRT_OVRID_RSN_CD VARCHAR2 (30)

ERLST_DEENRT_DT DATE


ENRT_CVG_STRT_DT DATE
Yes
ENRT_CVG_THRU_DT DATE
Yes
ENRT_OVRID_THRU_DT DATE


PEN_ATTRIBUTE_CATEGORY VARCHAR2 (30)

PEN_ATTRIBUTE1 VARCHAR2 (150)

PEN_ATTRIBUTE2 VARCHAR2 (150)

PEN_ATTRIBUTE3 VARCHAR2 (150)

PEN_ATTRIBUTE4 VARCHAR2 (150)

PEN_ATTRIBUTE5 VARCHAR2 (150)

PEN_ATTRIBUTE6 VARCHAR2 (150)

PEN_ATTRIBUTE7 VARCHAR2 (150)

PEN_ATTRIBUTE8 VARCHAR2 (150)

PEN_ATTRIBUTE9 VARCHAR2 (150)

PEN_ATTRIBUTE10 VARCHAR2 (150)

PEN_ATTRIBUTE11 VARCHAR2 (150)

PEN_ATTRIBUTE12 VARCHAR2 (150)

PEN_ATTRIBUTE13 VARCHAR2 (150)

PEN_ATTRIBUTE14 VARCHAR2 (150)

PEN_ATTRIBUTE15 VARCHAR2 (150)

PEN_ATTRIBUTE16 VARCHAR2 (150)

PEN_ATTRIBUTE17 VARCHAR2 (150)

PEN_ATTRIBUTE18 VARCHAR2 (150)

PEN_ATTRIBUTE19 VARCHAR2 (150)

PEN_ATTRIBUTE20 VARCHAR2 (150)

PEN_ATTRIBUTE21 VARCHAR2 (150)

PEN_ATTRIBUTE22 VARCHAR2 (150)

PEN_ATTRIBUTE23 VARCHAR2 (150)

PEN_ATTRIBUTE24 VARCHAR2 (150)

PEN_ATTRIBUTE25 VARCHAR2 (150)

PEN_ATTRIBUTE26 VARCHAR2 (150)

PEN_ATTRIBUTE27 VARCHAR2 (150)

PEN_ATTRIBUTE28 VARCHAR2 (150)

PEN_ATTRIBUTE29 VARCHAR2 (150)

PEN_ATTRIBUTE30 VARCHAR2 (150)

LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated primary key. Increments by one each update.
PER_IN_LER_ID NUMBER (15)
Foreign Key to BEN_PER_IN_LER.
BNFT_TYP_CD VARCHAR2 (30)

BNFT_NNMNTRY_UOM VARCHAR2 (30)

COMP_LVL_CD VARCHAR2 (30)
BNFT_ORDR_NUM NUMBER (15)
Retrofitted
PRTT_ENRT_RSLT_STAT_CD VARCHAR2 (30)
PL_ORDR_NUM NUMBER (15)

PLIP_ORDR_NUM NUMBER (15)

PTIP_ORDR_NUM NUMBER (15)

OIPL_ORDR_NUM NUMBER (15)

Query Text

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


SELECT ROW_ID
,      PRTT_ENRT_RSLT_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      OIPL_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      PGM_ID
,      PGM_NAME
,      PL_ID
,      RPLCS_SSPNDD_RSLT_ID
,      PTIP_ID
,      PL_TYP_ID
,      LER_ID
,      SSPNDD_FLAG
,      PRTT_IS_CVRD_FLAG
,      BNFT_AMT
,      UOM
,      ORGNL_ENRT_DT
,      ENRT_MTHD_CD
,      NO_LNGR_ELIG_FLAG
,      ENRT_OVRIDN_FLAG
,      ENRT_OVRID_RSN_CD
,      ERLST_DEENRT_DT
,      ENRT_CVG_STRT_DT
,      ENRT_CVG_THRU_DT
,      ENRT_OVRID_THRU_DT
,      PEN_ATTRIBUTE_CATEGORY
,      PEN_ATTRIBUTE1
,      PEN_ATTRIBUTE2
,      PEN_ATTRIBUTE3
,      PEN_ATTRIBUTE4
,      PEN_ATTRIBUTE5
,      PEN_ATTRIBUTE6
,      PEN_ATTRIBUTE7
,      PEN_ATTRIBUTE8
,      PEN_ATTRIBUTE9
,      PEN_ATTRIBUTE10
,      PEN_ATTRIBUTE11
,      PEN_ATTRIBUTE12
,      PEN_ATTRIBUTE13
,      PEN_ATTRIBUTE14
,      PEN_ATTRIBUTE15
,      PEN_ATTRIBUTE16
,      PEN_ATTRIBUTE17
,      PEN_ATTRIBUTE18
,      PEN_ATTRIBUTE19
,      PEN_ATTRIBUTE20
,      PEN_ATTRIBUTE21
,      PEN_ATTRIBUTE22
,      PEN_ATTRIBUTE23
,      PEN_ATTRIBUTE24
,      PEN_ATTRIBUTE25
,      PEN_ATTRIBUTE26
,      PEN_ATTRIBUTE27
,      PEN_ATTRIBUTE28
,      PEN_ATTRIBUTE29
,      PEN_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      PER_IN_LER_ID
,      BNFT_TYP_CD
,      BNFT_NNMNTRY_UOM
,      COMP_LVL_CD
,      BNFT_ORDR_NUM
,      PRTT_ENRT_RSLT_STAT_CD
,      PL_ORDR_NUM
,      PLIP_ORDR_NUM
,      PTIP_ORDR_NUM
,      OIPL_ORDR_NUM
FROM APPS.BEN_PRTT_ENRT_RSLT_V;

Dependencies

[top of page]

APPS.BEN_PRTT_ENRT_RSLT_V references the following:

SchemaAPPS
SynonymBEN_PGM_F
SynonymBEN_PRTT_ENRT_RSLT_F
SynonymFND_SESSIONS

APPS.BEN_PRTT_ENRT_RSLT_V is not referenced by any database object