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

VIEW: APPS.BEN_BACK_OUT_CHC_BNFT_V

Object Details
Object Name: BEN_BACK_OUT_CHC_BNFT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BEN_BACK_OUT_CHC_BNFT_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
PER_IN_LER_ID NUMBER (15) Yes Foreign Key to BEN_PER_IN_LER.
PIL_ELCTBL_CHC_POPL_ID NUMBER (15)
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign Key to HR_ORGANIZATION_UNITS
PL_ID NUMBER (15)
Foreign Key to BEN_PL_F.
OIPL_ID NUMBER (15)
Foreign Key to BEN_OIPL_F.
VAL NUMBER

PL_TYP_ID NUMBER (15)
NNMNTRY_UOM VARCHAR2 (30)
CRNTLY_ENRD_FLAG VARCHAR2 (30) Yes
ENRT_CVG_STRT_DT_CD VARCHAR2 (30)
ENRT_CVG_STRT_DT DATE

DPNT_DSGN_CD VARCHAR2 (30)
LER_CHG_DPNT_CVG_CD VARCHAR2 (30)
DPNT_CVG_STRT_DT_CD VARCHAR2 (30)
BNFT_TYP_CD VARCHAR2 (30)
CVG_MLT_CD VARCHAR2 (30)
ENTR_VAL_AT_ENRT_FLAG VARCHAR2 (30)
MN_VAL NUMBER

MX_VAL NUMBER

INCRMT_VAL NUMBER

DFLT_VAL NUMBER

ELCTBL_FLAG VARCHAR2 (30) Yes
CTFN_RQD_FLAG VARCHAR2 (30) Yes
MUST_ENRL_ANTHR_PL_ID NUMBER (15)
ELIG_PER_ELCTBL_CHC_ID NUMBER (15) Yes
FAKE_CHOICE_ID NUMBER

ERLST_DEENRT_DT DATE

ENRT_BNFT_ID NUMBER (15)
DFLT_FLAG VARCHAR2 (30) Yes
MNDTRY_FLAG VARCHAR2 (30) Yes
AUTO_ENRT_FLAG VARCHAR2 (30) Yes
ROLL_CRS_FLAG VARCHAR2 (30) Yes
PTIP_ORDR_NUM NUMBER (15)
PLIP_ORDR_NUM NUMBER (15)
PL_ORDR_NUM NUMBER (15)
OIPL_ORDR_NUM NUMBER (15)
ENB_ORDR_NUM NUMBER (15)
EPE_ATTRIBUTE_CATEGORY VARCHAR2 (30)
EPE_ATTRIBUTE1 VARCHAR2 (150)
EPE_ATTRIBUTE2 VARCHAR2 (150)
EPE_ATTRIBUTE3 VARCHAR2 (150)
EPE_ATTRIBUTE4 VARCHAR2 (150)
EPE_ATTRIBUTE5 VARCHAR2 (150)
EPE_ATTRIBUTE6 VARCHAR2 (150)
EPE_ATTRIBUTE7 VARCHAR2 (150)
EPE_ATTRIBUTE8 VARCHAR2 (150)
EPE_ATTRIBUTE9 VARCHAR2 (150)
EPE_ATTRIBUTE10 VARCHAR2 (150)
EPE_ATTRIBUTE11 VARCHAR2 (150)
EPE_ATTRIBUTE12 VARCHAR2 (150)
EPE_ATTRIBUTE13 VARCHAR2 (150)
EPE_ATTRIBUTE14 VARCHAR2 (150)
EPE_ATTRIBUTE15 VARCHAR2 (150)
EPE_ATTRIBUTE16 VARCHAR2 (150)
EPE_ATTRIBUTE17 VARCHAR2 (150)
EPE_ATTRIBUTE18 VARCHAR2 (150)
EPE_ATTRIBUTE19 VARCHAR2 (150)
EPE_ATTRIBUTE20 VARCHAR2 (150)
EPE_ATTRIBUTE21 VARCHAR2 (150)
EPE_ATTRIBUTE22 VARCHAR2 (150)
EPE_ATTRIBUTE23 VARCHAR2 (150)
EPE_ATTRIBUTE24 VARCHAR2 (150)
EPE_ATTRIBUTE25 VARCHAR2 (150)
EPE_ATTRIBUTE26 VARCHAR2 (150)
EPE_ATTRIBUTE27 VARCHAR2 (150)
EPE_ATTRIBUTE28 VARCHAR2 (150)
EPE_ATTRIBUTE29 VARCHAR2 (150)
EPE_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.
Query Text

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


SELECT PER_IN_LER_ID
,      PIL_ELCTBL_CHC_POPL_ID
,      BUSINESS_GROUP_ID
,      PL_ID
,      OIPL_ID
,      VAL
,      PL_TYP_ID
,      NNMNTRY_UOM
,      CRNTLY_ENRD_FLAG
,      ENRT_CVG_STRT_DT_CD
,      ENRT_CVG_STRT_DT
,      DPNT_DSGN_CD
,      LER_CHG_DPNT_CVG_CD
,      DPNT_CVG_STRT_DT_CD
,      BNFT_TYP_CD
,      CVG_MLT_CD
,      ENTR_VAL_AT_ENRT_FLAG
,      MN_VAL
,      MX_VAL
,      INCRMT_VAL
,      DFLT_VAL
,      ELCTBL_FLAG
,      CTFN_RQD_FLAG
,      MUST_ENRL_ANTHR_PL_ID
,      ELIG_PER_ELCTBL_CHC_ID
,      FAKE_CHOICE_ID
,      ERLST_DEENRT_DT
,      ENRT_BNFT_ID
,      DFLT_FLAG
,      MNDTRY_FLAG
,      AUTO_ENRT_FLAG
,      ROLL_CRS_FLAG
,      PTIP_ORDR_NUM
,      PLIP_ORDR_NUM
,      PL_ORDR_NUM
,      OIPL_ORDR_NUM
,      ENB_ORDR_NUM
,      EPE_ATTRIBUTE_CATEGORY
,      EPE_ATTRIBUTE1
,      EPE_ATTRIBUTE2
,      EPE_ATTRIBUTE3
,      EPE_ATTRIBUTE4
,      EPE_ATTRIBUTE5
,      EPE_ATTRIBUTE6
,      EPE_ATTRIBUTE7
,      EPE_ATTRIBUTE8
,      EPE_ATTRIBUTE9
,      EPE_ATTRIBUTE10
,      EPE_ATTRIBUTE11
,      EPE_ATTRIBUTE12
,      EPE_ATTRIBUTE13
,      EPE_ATTRIBUTE14
,      EPE_ATTRIBUTE15
,      EPE_ATTRIBUTE16
,      EPE_ATTRIBUTE17
,      EPE_ATTRIBUTE18
,      EPE_ATTRIBUTE19
,      EPE_ATTRIBUTE20
,      EPE_ATTRIBUTE21
,      EPE_ATTRIBUTE22
,      EPE_ATTRIBUTE23
,      EPE_ATTRIBUTE24
,      EPE_ATTRIBUTE25
,      EPE_ATTRIBUTE26
,      EPE_ATTRIBUTE27
,      EPE_ATTRIBUTE28
,      EPE_ATTRIBUTE29
,      EPE_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
FROM APPS.BEN_BACK_OUT_CHC_BNFT_V;

Dependencies

[top of page]

APPS.BEN_BACK_OUT_CHC_BNFT_V references the following:

SchemaAPPS
SynonymBEN_ELIG_PER_ELCTBL_CHC
SynonymBEN_ENRT_BNFT

APPS.BEN_BACK_OUT_CHC_BNFT_V is not referenced by any database object