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

VIEW: APPS.BENBV_CWB_PERSON_RATES_V

Object Details
Object Name: BENBV_CWB_PERSON_RATES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BENBV_CWB_PERSON_RATES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
LF_EVT_OCRD_DT DATE
Yes Life Event Occured Date
WS_VAL NUMBER

Worksheet Value.
WS_MN_VAL NUMBER

Worksheet Min Value.
WS_MX_VAL NUMBER

Worksheet Max Value.
WS_INCR_VAL NUMBER

Worksheet Incr Value.
ELIG_SAL_VAL NUMBER

Eligible Salary.
STAT_SAL_VAL NUMBER

Stated Salary.
OTH_COMP_VAL NUMBER

Other Compensation.
TOT_COMP_VAL NUMBER

Total Compensation.
MISC1_VAL NUMBER

Miscellaneous 1 Value.
MISC2_VAL NUMBER

Miscellaneous 2 Value.
MISC3_VAL NUMBER

Miscellaneous 3 Value.
REC_VAL NUMBER

Recommended Value.
REC_MN_VAL NUMBER

Recommended Min Value.
REC_MX_VAL NUMBER

Recommended Max Value.
REC_INCR_VAL NUMBER

Recommended Incr Value.
WS_VAL_LAST_UPD_DATE DATE

Worksheet Update Date.
WS_VAL_LAST_UPD_BY NUMBER (15)
Worksheet Updated by Person.
ELIG_OVRID_DT DATE

Eligibility Override Date.
COPY_DIST_BDGT_VAL NUMBER

Distribution Budget Value.
COPY_WS_BDGT_VAL NUMBER

Worksheet Budget Value.
COPY_RSRV_VAL NUMBER

Reserve Budget Value.
COPY_DIST_BDGT_MN_VAL NUMBER

Distribution Budget Min Value .
COPY_DIST_BDGT_MX_VAL NUMBER

Distribution Budget Max Value .
COPY_DIST_BDGT_INCR_VAL NUMBER

Distribution Budget Incr Value .
COPY_WS_BDGT_MN_VAL NUMBER

Worksheet Budget Min Value.
COPY_WS_BDGT_MX_VAL NUMBER

Worksheet Budget Max Value.
COPY_WS_BDGT_INCR_VAL NUMBER

Worksheet Budget Incr Value.
COPY_RSRV_MN_VAL NUMBER

Reserve Budget Min Value.
COPY_RSRV_MX_VAL NUMBER

Reserve Budget Max Value.
COPY_RSRV_INCR_VAL NUMBER

Reserve Budget Incr Value.
COPY_DIST_BDGT_ISS_VAL NUMBER

Distribution Budget Issued Value.
COPY_WS_BDGT_ISS_VAL NUMBER

Worksheet Budget Issued Value.
COPY_DIST_BDGT_ISS_DATE DATE

Distribution Budget Issued Date.
COPY_WS_BDGT_ISS_DATE DATE

Worksheet Budget Issued Date.
COMP_POSTING_DATE DATE

Compensation Posting Date.
WS_RT_START_DATE DATE

Worksheet Rate Start Date.
PLAN VARCHAR2 (4000)
Plan.
OPTION_IN_PLAN VARCHAR2 (4000)
Option in Plan.
GROUP_PLAN VARCHAR2 (4000)
Group Plan.
GROUP_OPTION_IN_PLAN VARCHAR2 (4000)
Group Option in Plan.
INELIG_RSN_CD VARCHAR2 (30)
Ineligible Reason (Lookup code based on lookup type BEN_INELG_RSN)
INELIG_RSN_CD_M VARCHAR2 (4000)
Ineligible Reason (Lookup meaning based on lookup type BEN_INELG_RSN)
ELIG_FLAG VARCHAR2 (30)
Eligible Flag(Lookup code based on lookup type YES_NO)
ELIG_FLAG_M VARCHAR2 (4000)
Eligible Flag(Lookup meaning based on lookup type YES_NO)
PERSON_RATE_ID NUMBER (15) Yes Person Rate Primary Key.
GROUP_PER_IN_LER_ID NUMBER (15) Yes Group Per in Ler ID
PL_ID NUMBER (15) Yes Plan ( Foreign key to BEN_PL_F)
OIPL_ID NUMBER (15)
Option in Plan ( Foreign key to BEN_OIPL_F)
GROUP_PL_ID NUMBER (15) Yes Group Plan.
GROUP_OIPL_ID NUMBER (15)
Group Option.
PERSON_ID NUMBER (15)
Person. ( Foreign key to PER_ALL_PEOPLE_F)
ASSIGNMENT_ID NUMBER (15)
Assignment ( Foreign key to PER_ALL_ASSIGNMENTS_F)
PAY_PROPOSAL_ID NUMBER (15)
Pay Proposal.
ELEMENT_ENTRY_VALUE_ID NUMBER (15)
Element Entry Value.
ELIG_OVRID_PERSON_ID NUMBER (15)
Eligibility Override by Person.
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).
CREATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
Query Text

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


SELECT LF_EVT_OCRD_DT
,      WS_VAL
,      WS_MN_VAL
,      WS_MX_VAL
,      WS_INCR_VAL
,      ELIG_SAL_VAL
,      STAT_SAL_VAL
,      OTH_COMP_VAL
,      TOT_COMP_VAL
,      MISC1_VAL
,      MISC2_VAL
,      MISC3_VAL
,      REC_VAL
,      REC_MN_VAL
,      REC_MX_VAL
,      REC_INCR_VAL
,      WS_VAL_LAST_UPD_DATE
,      WS_VAL_LAST_UPD_BY
,      ELIG_OVRID_DT
,      COPY_DIST_BDGT_VAL
,      COPY_WS_BDGT_VAL
,      COPY_RSRV_VAL
,      COPY_DIST_BDGT_MN_VAL
,      COPY_DIST_BDGT_MX_VAL
,      COPY_DIST_BDGT_INCR_VAL
,      COPY_WS_BDGT_MN_VAL
,      COPY_WS_BDGT_MX_VAL
,      COPY_WS_BDGT_INCR_VAL
,      COPY_RSRV_MN_VAL
,      COPY_RSRV_MX_VAL
,      COPY_RSRV_INCR_VAL
,      COPY_DIST_BDGT_ISS_VAL
,      COPY_WS_BDGT_ISS_VAL
,      COPY_DIST_BDGT_ISS_DATE
,      COPY_WS_BDGT_ISS_DATE
,      COMP_POSTING_DATE
,      WS_RT_START_DATE
,      PLAN
,      OPTION_IN_PLAN
,      GROUP_PLAN
,      GROUP_OPTION_IN_PLAN
,      INELIG_RSN_CD
,      INELIG_RSN_CD_M
,      ELIG_FLAG
,      ELIG_FLAG_M
,      PERSON_RATE_ID
,      GROUP_PER_IN_LER_ID
,      PL_ID
,      OIPL_ID
,      GROUP_PL_ID
,      GROUP_OIPL_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      PAY_PROPOSAL_ID
,      ELEMENT_ENTRY_VALUE_ID
,      ELIG_OVRID_PERSON_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.BENBV_CWB_PERSON_RATES_V;

Dependencies

[top of page]

APPS.BENBV_CWB_PERSON_RATES_V references the following:

SchemaAPPS
PL/SQL PackageBEN_BIS_UTILS - show dependent code
SynonymBEN_CWB_PERSON_RATES
PL/SQL PackageHR_BIS - show dependent code

APPS.BENBV_CWB_PERSON_RATES_V is not referenced by any database object