[Home] [Help] [Dependency Information]
Object Name: | BEN_ENRT_USED_INFO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BEN.BEN_ENRT_USED_INFO_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
|
|
|