Skip to content

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

VIEW: BEN.BEN_CWB_PL_DSGN#

Object Details
Object Name: BEN_CWB_PL_DSGN#
Object Type: VIEW
Owner: BEN
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PL_ID NUMBER (15) Yes
LF_EVT_OCRD_DT DATE
Yes
OIPL_ID NUMBER (15) Yes
EFFECTIVE_DATE DATE

NAME VARCHAR2 (240)
GROUP_PL_ID NUMBER (15)
GROUP_OIPL_ID NUMBER (15)
OPT_HIDDEN_FLAG VARCHAR2 (30)
OPT_ID NUMBER (15)
PL_UOM VARCHAR2 (30)
PL_ORDR_NUM NUMBER (15)
OIPL_ORDR_NUM NUMBER (15)
PL_XCHG_RATE NUMBER

OPT_COUNT NUMBER (3)
USES_BDGT_FLAG VARCHAR2 (30)
PRSRV_BDGT_CD VARCHAR2 (30)
UPD_START_DT DATE

UPD_END_DT DATE

APPROVAL_MODE VARCHAR2 (30)
ENRT_PERD_START_DT DATE

ENRT_PERD_END_DT DATE

YR_PERD_START_DT DATE

YR_PERD_END_DT DATE

WTHN_YR_START_DT DATE

WTHN_YR_END_DT DATE

ENRT_PERD_ID NUMBER (15)
YR_PERD_ID NUMBER (15)
BUSINESS_GROUP_ID NUMBER (15)
PERF_REVW_STRT_DT DATE

ASG_UPDT_EFF_DATE DATE

EMP_INTERVIEW_TYP_CD VARCHAR2 (30)
SALARY_CHANGE_REASON VARCHAR2 (30)
WS_ABR_ID NUMBER (15)
WS_NNMNTRY_UOM VARCHAR2 (30)
WS_RNDG_CD VARCHAR2 (30)
WS_SUB_ACTY_TYP_CD VARCHAR2 (30)
DIST_BDGT_ABR_ID NUMBER (15)
DIST_BDGT_NNMNTRY_UOM VARCHAR2 (30)
DIST_BDGT_RNDG_CD VARCHAR2 (30)
WS_BDGT_ABR_ID NUMBER (15)
WS_BDGT_NNMNTRY_UOM VARCHAR2 (30)
WS_BDGT_RNDG_CD VARCHAR2 (30)
RSRV_ABR_ID NUMBER (15)
RSRV_NNMNTRY_UOM VARCHAR2 (30)
RSRV_RNDG_CD VARCHAR2 (30)
ELIG_SAL_ABR_ID NUMBER (15)
ELIG_SAL_NNMNTRY_UOM VARCHAR2 (30)
ELIG_SAL_RNDG_CD VARCHAR2 (30)
MISC1_ABR_ID NUMBER (15)
MISC1_NNMNTRY_UOM VARCHAR2 (30)
MISC1_RNDG_CD VARCHAR2 (30)
MISC2_ABR_ID NUMBER (15)
MISC2_NNMNTRY_UOM VARCHAR2 (30)
MISC2_RNDG_CD VARCHAR2 (30)
MISC3_ABR_ID NUMBER (15)
MISC3_NNMNTRY_UOM VARCHAR2 (30)
MISC3_RNDG_CD VARCHAR2 (30)
STAT_SAL_ABR_ID NUMBER (15)
STAT_SAL_NNMNTRY_UOM VARCHAR2 (30)
STAT_SAL_RNDG_CD VARCHAR2 (30)
REC_ABR_ID NUMBER (15)
REC_NNMNTRY_UOM VARCHAR2 (30)
REC_RNDG_CD VARCHAR2 (30)
TOT_COMP_ABR_ID NUMBER (15)
TOT_COMP_NNMNTRY_UOM VARCHAR2 (30)
TOT_COMP_RNDG_CD VARCHAR2 (30)
OTH_COMP_ABR_ID NUMBER (15)
OTH_COMP_NNMNTRY_UOM VARCHAR2 (30)
OTH_COMP_RNDG_CD VARCHAR2 (30)
ACTUAL_FLAG VARCHAR2 (30)
ACTY_REF_PERD_CD VARCHAR2 (30)
LEGISLATION_CODE VARCHAR2 (30)
PL_ANNULIZATION_FACTOR NUMBER

PL_STAT_CD VARCHAR2 (30)
WS_AMT_EDIT_CD VARCHAR2 (30)
WS_AMT_EDIT_ENF_CD_FOR_NULLS VARCHAR2 (30)
WS_OVER_BUDGET_EDIT_CD VARCHAR2 (30)
WS_OVER_BUDGET_TOLERANCE_PCT NUMBER

BDGT_OVER_BUDGET_EDIT_CD VARCHAR2 (30)
BDGT_OVER_BUDGET_TOLERANCE_PCT NUMBER

UOM_PRECISION NUMBER

WS_ELEMENT_TYPE_ID NUMBER (15)
DATA_FREEZE_DATE DATE

AUTO_DISTR_FLAG VARCHAR2 (30)
PQH_DOCUMENT_SHORT_NAME VARCHAR2 (30)
OBJECT_VERSION_NUMBER NUMBER (9)
WS_INPUT_VALUE_ID NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

OVRID_RT_STRT_DT DATE

OVR_PERF_REVW_STRT_DT DATE

DO_NOT_PROCESS_FLAG VARCHAR2 (30)
CUSTOM_INTEGRATOR VARCHAR2 (30)
POST_ZERO_SALARY_INCREASE VARCHAR2 (30)
SHOW_APPRAISALS_N_DAYS NUMBER (15)
GRADE_RANGE_VALIDATION VARCHAR2 (30)
EMAIL_PASSWORD_PROTECTED VARCHAR2 (30)
EMAIL_CC_MANAGER VARCHAR2 (30)
EMAIL_SUBJECT VARCHAR2 (480)
EMAIL_CONTENT CLOB (4000)
EMAIL_SAMPLE_ADDRESS VARCHAR2 (240)
Query Text

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


SELECT PL_ID
,      LF_EVT_OCRD_DT
,      OIPL_ID
,      EFFECTIVE_DATE
,      NAME
,      GROUP_PL_ID
,      GROUP_OIPL_ID
,      OPT_HIDDEN_FLAG
,      OPT_ID
,      PL_UOM
,      PL_ORDR_NUM
,      OIPL_ORDR_NUM
,      PL_XCHG_RATE
,      OPT_COUNT
,      USES_BDGT_FLAG
,      PRSRV_BDGT_CD
,      UPD_START_DT
,      UPD_END_DT
,      APPROVAL_MODE
,      ENRT_PERD_START_DT
,      ENRT_PERD_END_DT
,      YR_PERD_START_DT
,      YR_PERD_END_DT
,      WTHN_YR_START_DT
,      WTHN_YR_END_DT
,      ENRT_PERD_ID
,      YR_PERD_ID
,      BUSINESS_GROUP_ID
,      PERF_REVW_STRT_DT
,      ASG_UPDT_EFF_DATE
,      EMP_INTERVIEW_TYP_CD
,      SALARY_CHANGE_REASON
,      WS_ABR_ID
,      WS_NNMNTRY_UOM
,      WS_RNDG_CD
,      WS_SUB_ACTY_TYP_CD
,      DIST_BDGT_ABR_ID
,      DIST_BDGT_NNMNTRY_UOM
,      DIST_BDGT_RNDG_CD
,      WS_BDGT_ABR_ID
,      WS_BDGT_NNMNTRY_UOM
,      WS_BDGT_RNDG_CD
,      RSRV_ABR_ID
,      RSRV_NNMNTRY_UOM
,      RSRV_RNDG_CD
,      ELIG_SAL_ABR_ID
,      ELIG_SAL_NNMNTRY_UOM
,      ELIG_SAL_RNDG_CD
,      MISC1_ABR_ID
,      MISC1_NNMNTRY_UOM
,      MISC1_RNDG_CD
,      MISC2_ABR_ID
,      MISC2_NNMNTRY_UOM
,      MISC2_RNDG_CD
,      MISC3_ABR_ID
,      MISC3_NNMNTRY_UOM
,      MISC3_RNDG_CD
,      STAT_SAL_ABR_ID
,      STAT_SAL_NNMNTRY_UOM
,      STAT_SAL_RNDG_CD
,      REC_ABR_ID
,      REC_NNMNTRY_UOM
,      REC_RNDG_CD
,      TOT_COMP_ABR_ID
,      TOT_COMP_NNMNTRY_UOM
,      TOT_COMP_RNDG_CD
,      OTH_COMP_ABR_ID
,      OTH_COMP_NNMNTRY_UOM
,      OTH_COMP_RNDG_CD
,      ACTUAL_FLAG
,      ACTY_REF_PERD_CD
,      LEGISLATION_CODE
,      PL_ANNULIZATION_FACTOR
,      PL_STAT_CD
,      WS_AMT_EDIT_CD
,      WS_AMT_EDIT_ENF_CD_FOR_NULLS
,      WS_OVER_BUDGET_EDIT_CD
,      WS_OVER_BUDGET_TOLERANCE_PCT
,      BDGT_OVER_BUDGET_EDIT_CD
,      BDGT_OVER_BUDGET_TOLERANCE_PCT
,      UOM_PRECISION
,      WS_ELEMENT_TYPE_ID
,      DATA_FREEZE_DATE
,      AUTO_DISTR_FLAG
,      PQH_DOCUMENT_SHORT_NAME
,      OBJECT_VERSION_NUMBER
,      WS_INPUT_VALUE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OVRID_RT_STRT_DT
,      OVR_PERF_REVW_STRT_DT
,      DO_NOT_PROCESS_FLAG
,      CUSTOM_INTEGRATOR
,      POST_ZERO_SALARY_INCREASE
,      SHOW_APPRAISALS_N_DAYS
,      GRADE_RANGE_VALIDATION
,      EMAIL_PASSWORD_PROTECTED
,      EMAIL_CC_MANAGER
,      EMAIL_SUBJECT
,      EMAIL_CONTENT
,      EMAIL_SAMPLE_ADDRESS
FROM BEN.BEN_CWB_PL_DSGN#;

Dependencies

[top of page]

BEN.BEN_CWB_PL_DSGN# references the following:

SchemaBEN
TableBEN_CWB_PL_DSGN
BEN.BEN_CWB_PL_DSGN# is referenced by following:

SchemaAPPS
SynonymBEN_CWB_PL_DSGN
TriggerBEN_CWB_PL_DSGN_WHO