[Home] [Help] [Dependency Information]
Object Name: | BEN_PNDG_WRKFLW_APPRVLS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BEN.BEN_PNDG_WRKFLW_APPRVLS_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 |
---|---|---|---|---|
PERSON_ID | NUMBER | Foreign Key to PER_PEOPLE_F. | ||
ELIG_PER_ELCTBL_CHC_ID | NUMBER | |||
BNFT_AMT | NUMBER | |||
RT_VAL | NUMBER | |||
PL_OPT_NAME | VARCHAR2 | (2000) | ||
ENRT_CVG_STRT_DT | DATE | |||
RT_STRT_DT | DATE | |||
RT_END_DT | DATE | |||
LIMIT_RT_VAL | NUMBER | |||
JUSTIFICATION | VARCHAR2 | (2000) | ||
FREQUENCY | VARCHAR2 | (2000) | ||
RT_UOM_MEANING | VARCHAR2 | (2000) | ||
BNFT_UOM_MEANING | VARCHAR2 | (2000) | ||
ACTY_REF_PERD_MEANING | VARCHAR2 | (2000) | ||
BNFT_TYP_MEANING | VARCHAR2 | (2000) | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, ELIG_PER_ELCTBL_CHC_ID
, BNFT_AMT
, RT_VAL
, PL_OPT_NAME
, ENRT_CVG_STRT_DT
, RT_STRT_DT
, RT_END_DT
, LIMIT_RT_VAL
, JUSTIFICATION
, FREQUENCY
, RT_UOM_MEANING
, BNFT_UOM_MEANING
, ACTY_REF_PERD_MEANING
, BNFT_TYP_MEANING
, CREATION_DATE
, CREATED_BY
FROM APPS.BEN_PNDG_WRKFLW_APPRVLS_V;
APPS.BEN_PNDG_WRKFLW_APPRVLS_V is not referenced by any database object
|
|
|