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

VIEW: APPS.BEN_CWB_REP_COMP_DTL_V

Object Details
Object Name: BEN_CWB_REP_COMP_DTL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BEN_CWB_REP_COMP_DTL_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
MGRPERSONID NUMBER (15) Yes Manager Person Id
LEVELNUM NUMBER (15) Yes Level Number
STATUS VARCHAR2 (4000)
Status
TRANSACTIONDATE DATE

Transaction Date
EMPLOYEENAME VARCHAR2 (480)
Employee Name
BUSINESSGROUP VARCHAR2 (240)
Business group
COUNTRY VARCHAR2 (30)
Country
COMPPLAN VARCHAR2 (240)
Compensation Plan Name
COMPPLANID NUMBER (15) Yes Compensation Plan Id
LOCALPLAN VARCHAR2 (240)
Local Plan Name
LOCALPLANID NUMBER (15) Yes Local Plan Id
COMPONENTNAME VARCHAR2 (240)
Component Name
COMPONENTID NUMBER (15)
Component Id
COMPAMT NUMBER

Comensation Amount
COMPUOM VARCHAR2 (4000)
Compensation Units;Currency
CONVERTEDAMT NUMBER

Converted Amount
CONVERSIONUOM VARCHAR2 (30)
Conversion Currency
CONVERSIONEXCHGRATE NUMBER

Conversion Exchange Rate
ELIGIBLESAL NUMBER

Eligible Salary
COMPAMTPER NUMBER

Amount as Percentage of Eligible Salary
BASESAL NUMBER

Base Salary
BASESALFREQ VARCHAR2 (30)
Base Salary Frequency
NEWSAL NUMBER

New Salary
MISCRATE1 NUMBER

Misc Rate 1
MISCRATE2 NUMBER

Misc Rate 2
MISCRATE3 NUMBER

Misc Rate 3
RECOMMENDEDVAL NUMBER

Recommended Value
STATEDSAL NUMBER

Stated Salary
TOTALCOMP NUMBER

Total Compensation
OTHERCOMP NUMBER

Other Compensation
COMPAMTLMTS VARCHAR2 (83)
Compensation Amount Limits
RECRANGE VARCHAR2 (83)
Recommended Range
GRADE VARCHAR2 (240)
Grade
GRADERANGE VARCHAR2 (83)
Grade Range
GRADEMIDPOINT NUMBER

Grade Mid Point
JOB VARCHAR2 (700)
Job
JOBSEGMENT1 VARCHAR2 (60)
Job Segment 1
JOBSEGMENT2 VARCHAR2 (60)
Job Segment 2
JOBSEGMENT3 VARCHAR2 (60)
Job Segment 3
RANKING NUMBER

Ranking
RATING VARCHAR2 (80)
Rating
HIREDATE DATE

Hire Date
ORGANIZATION VARCHAR2 (240)
Organization
WKSHTMGR VARCHAR2 (480)
Worksheet Manager
CUSTOMSEG1 VARCHAR2 (150)
Custom Segment 1
CUSTOMSEG2 VARCHAR2 (150)
Custom Segment 2
CUSTOMSEG3 VARCHAR2 (150)
Custom Segment 3
CUSTOMSEG4 VARCHAR2 (150)
Custom Segment 4
CUSTOMSEG5 VARCHAR2 (150)
Custom Segment 5
CUSTOMSEG6 VARCHAR2 (150)
Custom Segment 6
CUSTOMSEG7 VARCHAR2 (150)
Custom Segment 7
CUSTOMSEG8 VARCHAR2 (150)
Custom Segment 8
CUSTOMSEG9 VARCHAR2 (150)
Custom Segment 9
CUSTOMSEG10 VARCHAR2 (150)
Custom Segment 10
CUSTOMSEG11 NUMBER

Custom Segment 11
CUSTOMSEG12 NUMBER

Custom Segment 12
CUSTOMSEG13 NUMBER

Custom Segment 13
CUSTOMSEG14 NUMBER

Custom Segment 14
CUSTOMSEG15 NUMBER

Custom Segment 15
CPIATTRIBUTE1 VARCHAR2 (150)
CPI Attribute 1
CPIATTRIBUTE2 VARCHAR2 (150)
CPI Attribute 2
CPIATTRIBUTE3 VARCHAR2 (150)
CPI Attribute 3
CPIATTRIBUTE4 VARCHAR2 (150)
CPI Attribute 4
CPIATTRIBUTE5 VARCHAR2 (150)
CPI Attribute 5
EMPLOYEEFULLNAME VARCHAR2 (240)
Employee Full Name
EMPNUMBER VARCHAR2 (30)
Employee Number
EMAIL VARCHAR2 (240)
Email
LEVEL1MGR VARCHAR2 (4000)
Level 1 Manager
LEVEL2MGR VARCHAR2 (4000)
Level 2 Manager
LEVEL3MGR VARCHAR2 (4000)
Level 3 Manager
LEVEL4MGR VARCHAR2 (4000)
Level 4 Manager
LEVEL5MGR VARCHAR2 (4000)
Level 5 Manager
LEVEL6MGR VARCHAR2 (4000)
Level 6 Manager
LEVEL7MGR VARCHAR2 (4000)
Level 7 Manager
LEVEL8MGR VARCHAR2 (4000)
Level 8 Manager
CUSTOMSEG16 NUMBER

Descriptive Flexfield Segment Column
CUSTOMSEG17 NUMBER

Descriptive Flexfield Segment Column
CUSTOMSEG18 NUMBER

Descriptive Flexfield Segment Column
CUSTOMSEG19 NUMBER

Descriptive Flexfield Segment Column
CUSTOMSEG20 NUMBER

Descriptive Flexfield Segment Column
PLANPERIOD VARCHAR2 (25)
Plan Period
Query Text

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


SELECT MGRPERSONID
,      LEVELNUM
,      STATUS
,      TRANSACTIONDATE
,      EMPLOYEENAME
,      BUSINESSGROUP
,      COUNTRY
,      COMPPLAN
,      COMPPLANID
,      LOCALPLAN
,      LOCALPLANID
,      COMPONENTNAME
,      COMPONENTID
,      COMPAMT
,      COMPUOM
,      CONVERTEDAMT
,      CONVERSIONUOM
,      CONVERSIONEXCHGRATE
,      ELIGIBLESAL
,      COMPAMTPER
,      BASESAL
,      BASESALFREQ
,      NEWSAL
,      MISCRATE1
,      MISCRATE2
,      MISCRATE3
,      RECOMMENDEDVAL
,      STATEDSAL
,      TOTALCOMP
,      OTHERCOMP
,      COMPAMTLMTS
,      RECRANGE
,      GRADE
,      GRADERANGE
,      GRADEMIDPOINT
,      JOB
,      JOBSEGMENT1
,      JOBSEGMENT2
,      JOBSEGMENT3
,      RANKING
,      RATING
,      HIREDATE
,      ORGANIZATION
,      WKSHTMGR
,      CUSTOMSEG1
,      CUSTOMSEG2
,      CUSTOMSEG3
,      CUSTOMSEG4
,      CUSTOMSEG5
,      CUSTOMSEG6
,      CUSTOMSEG7
,      CUSTOMSEG8
,      CUSTOMSEG9
,      CUSTOMSEG10
,      CUSTOMSEG11
,      CUSTOMSEG12
,      CUSTOMSEG13
,      CUSTOMSEG14
,      CUSTOMSEG15
,      CPIATTRIBUTE1
,      CPIATTRIBUTE2
,      CPIATTRIBUTE3
,      CPIATTRIBUTE4
,      CPIATTRIBUTE5
,      EMPLOYEEFULLNAME
,      EMPNUMBER
,      EMAIL
,      LEVEL1MGR
,      LEVEL2MGR
,      LEVEL3MGR
,      LEVEL4MGR
,      LEVEL5MGR
,      LEVEL6MGR
,      LEVEL7MGR
,      LEVEL8MGR
,      CUSTOMSEG16
,      CUSTOMSEG17
,      CUSTOMSEG18
,      CUSTOMSEG19
,      CUSTOMSEG20
,      PLANPERIOD
FROM APPS.BEN_CWB_REP_COMP_DTL_V;

Dependencies

[top of page]

APPS.BEN_CWB_REP_COMP_DTL_V references the following:

SchemaAPPS
SynonymBEN_CWB_GROUP_HRCHY
SynonymBEN_CWB_PERSON_INFO
SynonymBEN_CWB_PERSON_RATES
SynonymBEN_CWB_PL_DSGN
PL/SQL PackageBEN_CWB_UTILS - show dependent code
SynonymBEN_CWB_XCHG
SynonymBEN_PER_IN_LER
SynonymBEN_TRANSACTION
PL/SQL PackageFND_MESSAGE - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOOKUPS
SynonymPER_ASSIGNMENT_EXTRA_INFO
SynonymPER_GRADES_TL
SynonymPER_JOBS
SynonymPER_JOBS_TL
SynonymPER_JOB_DEFINITIONS
SchemaPUBLIC
SynonymDUAL

APPS.BEN_CWB_REP_COMP_DTL_V is not referenced by any database object