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

VIEW: APPS.BEN_ENRT_OVERRIDE_RATES_V

Object Details
Object Name: BEN_ENRT_OVERRIDE_RATES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BEN_ENRT_OVERRIDE_RATES_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
RT_TYP_CD VARCHAR2 (30)
TX_TYP_CD VARCHAR2 (30)
ACTY_TYP_CD VARCHAR2 (30)
MLT_CD VARCHAR2 (30)
RT_VAL NUMBER

RT_STRT_DT DATE

RT_END_DT DATE

ANN_RT_VAL VARCHAR2 (0)
BNFT_RT_TYP_CD VARCHAR2 (30)
CMCD_RT_VAL VARCHAR2 (0)
DSPLY_ON_ENRT_FLAG VARCHAR2 (30) Yes
ELCTNS_MADE_DT DATE

RT_OVRIDN_FLAG CHAR (1)
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign Key to HR_ORGANIZATION_UNITS
ACTY_BASE_RT_ID NUMBER (15) Yes
INPUT_VALUE_ID NUMBER (9)
ELEMENT_TYPE_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)
PLIP_ID NUMBER (15)
PTIP_ID NUMBER (15)
Foreign Key to BEN_PTIP_F.
OIPLIP_ID NUMBER (15)
Foreign Key to BEN_OIPLIP_F.
Query Text

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


SELECT RT_TYP_CD
,      TX_TYP_CD
,      ACTY_TYP_CD
,      MLT_CD
,      RT_VAL
,      RT_STRT_DT
,      RT_END_DT
,      ANN_RT_VAL
,      BNFT_RT_TYP_CD
,      CMCD_RT_VAL
,      DSPLY_ON_ENRT_FLAG
,      ELCTNS_MADE_DT
,      RT_OVRIDN_FLAG
,      BUSINESS_GROUP_ID
,      ACTY_BASE_RT_ID
,      INPUT_VALUE_ID
,      ELEMENT_TYPE_ID
,      PL_ID
,      OIPL_ID
,      PGM_ID
,      PLIP_ID
,      PTIP_ID
,      OIPLIP_ID
FROM APPS.BEN_ENRT_OVERRIDE_RATES_V;

Dependencies

[top of page]

APPS.BEN_ENRT_OVERRIDE_RATES_V references the following:

SchemaAPPS
SynonymBEN_ACTY_BASE_RT_F
SynonymFND_SESSIONS
APPS.BEN_ENRT_OVERRIDE_RATES_V is referenced by following:

SchemaPUBLIC
SynonymBEN_ENRT_OVERRIDE_RATES_V