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

VIEW: APPS.BENBV_CWB_PL_DSGN_V

Object Details
Object Name: BENBV_CWB_PL_DSGN_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BENBV_CWB_PL_DSGN_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
EFFECTIVE_DATE DATE

Effective Date
NAME VARCHAR2 (240)
Name.
PL_UOM VARCHAR2 (30)
Plan UOM
PL_ORDR_NUM NUMBER (15)
Plan Order
OIPL_ORDR_NUM NUMBER (15)
Option Order
PL_XCHG_RATE NUMBER

Plan Exchange Rate
OPT_COUNT NUMBER (3)
Option Count
UPD_START_DT DATE

Update Start Date
UPD_END_DT DATE

Update End Date
APPROVAL_MODE VARCHAR2 (30)
Approval Mode
ENRT_PERD_START_DT DATE

Enrollment Period Start Date
ENRT_PERD_END_DT DATE

Enrollment Period End Date
YR_PERD_END_DT DATE

Year Period End Date
WTHN_YR_START_DT DATE

Within Year Start Date
WTHN_YR_END_DT DATE

Within Year End Date
PERF_REVW_STRT_DT DATE

Performance Rating Update Date
ASG_UPDT_EFF_DATE DATE

Assignment Update Date
SALARY_CHANGE_REASON VARCHAR2 (30)
Salary Change Reason
WS_NNMNTRY_UOM VARCHAR2 (30)
Worksheet Rate Non-Monetary UOM
DIST_BDGT_NNMNTRY_UOM VARCHAR2 (30)
Distribution Budget Rate Non-Monetary UOM
WS_BDGT_NNMNTRY_UOM VARCHAR2 (30)
Worksheet Budget Rate Non-Monetary UOM
RSRV_NNMNTRY_UOM VARCHAR2 (30)
Reserve Budget Rate Non-Monetary UOM
ELIG_SAL_NNMNTRY_UOM VARCHAR2 (30)
Eligible Salary Rate Non-Monetary UOM
MISC1_NNMNTRY_UOM VARCHAR2 (30)
Miscellaneous 1 Rate Non-Monetary UOM
MISC2_NNMNTRY_UOM VARCHAR2 (30)
Miscellaneous 2 Rate Non-Monetary UOM
MISC3_NNMNTRY_UOM VARCHAR2 (30)
Miscellaneous 3 Rate Non-Monetary UOM
STAT_SAL_NNMNTRY_UOM VARCHAR2 (30)
Stated Salary Rate Non-Monetary UOM
REC_NNMNTRY_UOM VARCHAR2 (30)
Recommended Rate Non-Monetary UOM
TOT_COMP_NNMNTRY_UOM VARCHAR2 (30)
Total Compensation Non-Monetary UOM
OTH_COMP_NNMNTRY_UOM VARCHAR2 (30)
Other Compensation Non-Monetary UOM
YR_PERD_START_DT DATE

Year Period Start Date.
LEGISLATION_CODE VARCHAR2 (30)
Legislation code.
PL_ANNULIZATION_FACTOR NUMBER

Plan annualization factor.
UOM_PRECISION NUMBER

Unit of Money Precision
DATA_FREEZE_DATE DATE

BDGT_OVER_BUDGET_TOLERANCE_PCT NUMBER

WS_OVER_BUDGET_TOLERANCE_PCT NUMBER

PLAN VARCHAR2 (4000)
Plan.
OPTION_IN_PLAN VARCHAR2 (4000)
Option in Plan.
GROUP_PLAN_NAME VARCHAR2 (4000)
GROUP_OPTION_IN_PLAN VARCHAR2 (4000)
Group Option in Plan.
OPTION_NAME VARCHAR2 (4000)
Option Name.
PRSRV_BDGT_CD VARCHAR2 (30)
Preserve Budget Code (Lookup code based on lookup type BEN_PRSVR_BDGT)
PRSRV_BDGT_CD_M VARCHAR2 (4000)
Preserve Budget Code (Lookup meaning based on lookup type BEN_PRSVR_BDGT)
EMP_INTERVIEW_TYP_CD VARCHAR2 (30)
Performance Rating Type (Lookup code based on lookup type )
EMP_INTERVIEW_TYP_CD_M VARCHAR2 (4000)
Performance Rating Type (Lookup meaning based on lookup type )
WS_RNDG_CD VARCHAR2 (30)
Worksheet Rate Rounding Code (Lookup code based on lookup type BEN_RNDG)
WS_RNDG_CD_M VARCHAR2 (4000)
Worksheet Rate Rounding Code (Lookup meaning based on lookup type BEN_RNDG)
DIST_BDGT_RNDG_CD VARCHAR2 (30)
Distribution Budget Rate Rounding Code (Lookup code based on lookup type BEN_RNDG)
DIST_BDGT_RNDG_CD_M VARCHAR2 (4000)
Distribution Budget Rate Rounding Code (Lookup meaning based on lookup type BEN_RNDG)
WS_BDGT_RNDG_CD VARCHAR2 (30)
Worksheet Budget Rate Rounding Code (Lookup code based on lookup type BEN_RNDG)
WS_BDGT_RNDG_CD_M VARCHAR2 (4000)
Worksheet Budget Rate Rounding Code (Lookup meaning based on lookup type BEN_RNDG)
RSRV_RNDG_CD VARCHAR2 (30)
Reserve Budget Rate Rounding Code (Lookup code based on lookup type BEN_RNDG)
RSRV_RNDG_CD_M VARCHAR2 (4000)
Reserve Budget Rate Rounding Code (Lookup meaning based on lookup type BEN_RNDG)
ELIG_SAL_RNDG_CD VARCHAR2 (30)
Eligible Salary Rate Rounding Code (Lookup code based on lookup type BEN_RNDG)
ELIG_SAL_RNDG_CD_M VARCHAR2 (4000)
Eligible Salary Rate Rounding Code (Lookup meaning based on lookup type BEN_RNDG)
MISC1_RNDG_CD VARCHAR2 (30)
Miscellaneous 1 Rate Rounding Code (Lookup code based on lookup type BEN_RNDG)
MISC1_RNDG_CD_M VARCHAR2 (4000)
Miscellaneous 1 Rate Rounding Code (Lookup meaning based on lookup type BEN_RNDG)
MISC2_RNDG_CD VARCHAR2 (30)
Miscellaneous 2 Rate Rounding Code (Lookup code based on lookup type BEN_RNDG)
MISC2_RNDG_CD_M VARCHAR2 (4000)
Miscellaneous 2 Rate Rounding Code (Lookup meaning based on lookup type BEN_RNDG)
MISC3_RNDG_CD VARCHAR2 (30)
Miscellaneous 3 Rate Rounding Code (Lookup code based on lookup type BEN_RNDG)
MISC3_RNDG_CD_M VARCHAR2 (4000)
Miscellaneous 3 Rate Rounding Code (Lookup meaning based on lookup type BEN_RNDG)
STAT_SAL_RNDG_CD VARCHAR2 (30)
Stated Salary Rate Rounding Code (Lookup code based on lookup type BEN_RNDG)
STAT_SAL_RNDG_CD_M VARCHAR2 (4000)
Stated Salary Rate Rounding Code (Lookup meaning based on lookup type BEN_RNDG)
REC_RNDG_CD VARCHAR2 (30)
Recommended Rate Rounding Code (Lookup code based on lookup type BEN_RNDG)
REC_RNDG_CD_M VARCHAR2 (4000)
Recommended Rate Rounding Code (Lookup meaning based on lookup type BEN_RNDG)
TOT_COMP_RNDG_CD VARCHAR2 (30)
Total Compensation Rounding Code (Lookup code based on lookup type BEN_RNDG)
TOT_COMP_RNDG_CD_M VARCHAR2 (4000)
Total Compensation Rounding Code (Lookup meaning based on lookup type BEN_RNDG)
OTH_COMP_RNDG_CD VARCHAR2 (30)
Other Compensation Rounding Code (Lookup code based on lookup type BEN_RNDG)
OTH_COMP_RNDG_CD_M VARCHAR2 (4000)
Other Compensation Rounding Code (Lookup meaning based on lookup type BEN_RNDG)
WS_SUB_ACTY_TYP_CD VARCHAR2 (30)
(Lookup code based on lookup type BEN_SUB_ACTY_TYP)
WS_SUB_ACTY_TYP_CD_M VARCHAR2 (4000)
(Lookup meaning based on lookup type BEN_SUB_ACTY_TYP)
ACTY_REF_PERD_CD VARCHAR2 (30)
(Lookup code based on lookup type BEN_ACTY_REF_PERD)
ACTY_REF_PERD_CD_M VARCHAR2 (4000)
(Lookup meaning based on lookup type BEN_ACTY_REF_PERD)
PL_STAT_CD VARCHAR2 (30)
Plan Status Code (Lookup code based on lookup type BEN_STAT)
PL_STAT_CD_M VARCHAR2 (4000)
Plan status code (Lookup meaning based on lookup type BEN_STAT)
OPT_HIDDEN_FLAG VARCHAR2 (30)
Option Hidden Flag (Lookup code based on lookup type YES_NO)
OPT_HIDDEN_FLAG_M VARCHAR2 (4000)
Option Hidden Flag (Lookup meaning based on lookup type YES_NO)
USES_BDGT_FLAG VARCHAR2 (30)
Uses Budget (Lookup code based on lookup type YES_NO)
USES_BDGT_FLAG_M VARCHAR2 (4000)
Uses Budget (Lookup meaning based on lookup type YES_NO)
ACTUAL_FLAG VARCHAR2 (30)
Actual Flag (Lookup code based on lookup type YES_NO)
ACTUAL_FLAG_M VARCHAR2 (4000)
Actual Flag (Lookup meaning based on lookup type YES_NO)
BDGT_OVER_BUDGET_EDIT_CD VARCHAR2 (30)
BDGT_OVER_BUDGET_EDIT_CD_M VARCHAR2 (4000)
WS_OVER_BUDGET_EDIT_CD VARCHAR2 (30)
WS_OVER_BUDGET_EDIT_CD_M VARCHAR2 (4000)
WS_AMT_EDIT_CD VARCHAR2 (30)
WS_AMT_EDIT_CD_M VARCHAR2 (4000)
WS_AMT_EDIT_ENF_CD_FOR_NULLS VARCHAR2 (30)
WS_AMT_EDIT_ENF_CD_FOR_NULLS_M VARCHAR2 (4000)
PL_ID NUMBER (15) Yes Plan ( Foreign Key to BEN_PL_F)
OIPL_ID NUMBER (15) Yes Option in Plan.
GROUP_PL_ID NUMBER (15)
Group Plan ID
GROUP_OIPL_ID NUMBER (15)
Group Option in Plan
OPT_ID NUMBER (15)
Option
ENRT_PERD_ID NUMBER (15)
Enrollment Period
YR_PERD_ID NUMBER (15)
Year Period
BUSINESS_GROUP_ID NUMBER (15)
Foreign Key to HR_ORGANIZATIONAL_UNITS
WS_ABR_ID NUMBER (15)
Worksheet Rate
DIST_BDGT_ABR_ID NUMBER (15)
Distribution Budget Rate
WS_BDGT_ABR_ID NUMBER (15)
Worksheet Budget Rate
RSRV_ABR_ID NUMBER (15)
Reserve Budget Rate
ELIG_SAL_ABR_ID NUMBER (15)
Eligible Salary Rate
MISC1_ABR_ID NUMBER (15)
Miscellaneous 1 Rate
MISC2_ABR_ID NUMBER (15)
Miscellaneous 2 Rate
MISC3_ABR_ID NUMBER (15)
Miscellaneous 3 Rate
STAT_SAL_ABR_ID NUMBER (15)
Stated Salary Rate
REC_ABR_ID NUMBER (15)
Recommended Rate
TOT_COMP_ABR_ID NUMBER (15)
Total Compensation
OTH_COMP_ABR_ID NUMBER (15)
Other Compensation
WS_ELEMENT_TYPE_ID NUMBER (15)
Worksheet Element Type.
WS_INPUT_VALUE_ID NUMBER (15)
Worksheet Input Value
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
,      EFFECTIVE_DATE
,      NAME
,      PL_UOM
,      PL_ORDR_NUM
,      OIPL_ORDR_NUM
,      PL_XCHG_RATE
,      OPT_COUNT
,      UPD_START_DT
,      UPD_END_DT
,      APPROVAL_MODE
,      ENRT_PERD_START_DT
,      ENRT_PERD_END_DT
,      YR_PERD_END_DT
,      WTHN_YR_START_DT
,      WTHN_YR_END_DT
,      PERF_REVW_STRT_DT
,      ASG_UPDT_EFF_DATE
,      SALARY_CHANGE_REASON
,      WS_NNMNTRY_UOM
,      DIST_BDGT_NNMNTRY_UOM
,      WS_BDGT_NNMNTRY_UOM
,      RSRV_NNMNTRY_UOM
,      ELIG_SAL_NNMNTRY_UOM
,      MISC1_NNMNTRY_UOM
,      MISC2_NNMNTRY_UOM
,      MISC3_NNMNTRY_UOM
,      STAT_SAL_NNMNTRY_UOM
,      REC_NNMNTRY_UOM
,      TOT_COMP_NNMNTRY_UOM
,      OTH_COMP_NNMNTRY_UOM
,      YR_PERD_START_DT
,      LEGISLATION_CODE
,      PL_ANNULIZATION_FACTOR
,      UOM_PRECISION
,      DATA_FREEZE_DATE
,      BDGT_OVER_BUDGET_TOLERANCE_PCT
,      WS_OVER_BUDGET_TOLERANCE_PCT
,      PLAN
,      OPTION_IN_PLAN
,      GROUP_PLAN_NAME
,      GROUP_OPTION_IN_PLAN
,      OPTION_NAME
,      PRSRV_BDGT_CD
,      PRSRV_BDGT_CD_M
,      EMP_INTERVIEW_TYP_CD
,      EMP_INTERVIEW_TYP_CD_M
,      WS_RNDG_CD
,      WS_RNDG_CD_M
,      DIST_BDGT_RNDG_CD
,      DIST_BDGT_RNDG_CD_M
,      WS_BDGT_RNDG_CD
,      WS_BDGT_RNDG_CD_M
,      RSRV_RNDG_CD
,      RSRV_RNDG_CD_M
,      ELIG_SAL_RNDG_CD
,      ELIG_SAL_RNDG_CD_M
,      MISC1_RNDG_CD
,      MISC1_RNDG_CD_M
,      MISC2_RNDG_CD
,      MISC2_RNDG_CD_M
,      MISC3_RNDG_CD
,      MISC3_RNDG_CD_M
,      STAT_SAL_RNDG_CD
,      STAT_SAL_RNDG_CD_M
,      REC_RNDG_CD
,      REC_RNDG_CD_M
,      TOT_COMP_RNDG_CD
,      TOT_COMP_RNDG_CD_M
,      OTH_COMP_RNDG_CD
,      OTH_COMP_RNDG_CD_M
,      WS_SUB_ACTY_TYP_CD
,      WS_SUB_ACTY_TYP_CD_M
,      ACTY_REF_PERD_CD
,      ACTY_REF_PERD_CD_M
,      PL_STAT_CD
,      PL_STAT_CD_M
,      OPT_HIDDEN_FLAG
,      OPT_HIDDEN_FLAG_M
,      USES_BDGT_FLAG
,      USES_BDGT_FLAG_M
,      ACTUAL_FLAG
,      ACTUAL_FLAG_M
,      BDGT_OVER_BUDGET_EDIT_CD
,      BDGT_OVER_BUDGET_EDIT_CD_M
,      WS_OVER_BUDGET_EDIT_CD
,      WS_OVER_BUDGET_EDIT_CD_M
,      WS_AMT_EDIT_CD
,      WS_AMT_EDIT_CD_M
,      WS_AMT_EDIT_ENF_CD_FOR_NULLS
,      WS_AMT_EDIT_ENF_CD_FOR_NULLS_M
,      PL_ID
,      OIPL_ID
,      GROUP_PL_ID
,      GROUP_OIPL_ID
,      OPT_ID
,      ENRT_PERD_ID
,      YR_PERD_ID
,      BUSINESS_GROUP_ID
,      WS_ABR_ID
,      DIST_BDGT_ABR_ID
,      WS_BDGT_ABR_ID
,      RSRV_ABR_ID
,      ELIG_SAL_ABR_ID
,      MISC1_ABR_ID
,      MISC2_ABR_ID
,      MISC3_ABR_ID
,      STAT_SAL_ABR_ID
,      REC_ABR_ID
,      TOT_COMP_ABR_ID
,      OTH_COMP_ABR_ID
,      WS_ELEMENT_TYPE_ID
,      WS_INPUT_VALUE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.BENBV_CWB_PL_DSGN_V;

Dependencies

[top of page]

APPS.BENBV_CWB_PL_DSGN_V references the following:

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

APPS.BENBV_CWB_PL_DSGN_V is not referenced by any database object