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


VIEW: APPS.BEN_CWB_WS_DOWNLOAD_V

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


View for providing content into the Compensation Workbench Compensation Allocation worksheet download.


[View Source]

Columns
Name Datatype Length Mandatory Comments
EMP_NAME VARCHAR2 (480)
Employee Name
MGR_NAME VARCHAR2 (480)
Manager Name
RANK NUMBER

Rank
YEARS_EMPLOYED NUMBER

Number of Years Employed
BASE_SALARY NUMBER

Base Salary
PL_NAME VARCHAR2 (240)
Plan Name
PL_XCHG_RATE NUMBER

Exchange Rate defined for Plan
PL_STAT_SAL_VAL NUMBER

Stated Salary
PL_ELIG_SAL_VAL NUMBER

Eligible Salary
PL_TOT_COMP_VAL NUMBER

Total Compensation
PL_OTH_COMP_VAL NUMBER

Other Compensation
PL_WS_VAL NUMBER

Worksheet Value
PL_WS_MIN_VAL NUMBER

Worksheet minimum value
PL_WS_MAX_VAL NUMBER

Worksheet maximum value
PL_WS_INCR_VAL NUMBER

Worksheet Increment value
PL_REC_VAL NUMBER

Recommended Value for plan
PL_REC_MIN_VAL NUMBER

Recommended Minimum Value for plan
PL_REC_MAX_VAL NUMBER

Recommended Maximum Value for plan
PL_MISC1_VAL NUMBER

Miscellaneous Value 1
PL_MISC2_VAL NUMBER

Miscellaneous Value 1
PL_MISC3_VAL NUMBER

Miscellaneous Value 1
PL_WS_LAST_UPD_DATE DATE

Worksheet Last updated date
PL_WS_LAST_UPD_NAME VARCHAR2 (240)
Name of the person who has last updated the worksheet
OPT1_NAME VARCHAR2 (240)
Option 1 Name
OPT1_XCHG_RATE NUMBER

Exchange rate defined for Option 1
OPT1_STAT_SAL_VAL NUMBER

Stated salary for option 1
OPT1_ELIG_SAL_VAL NUMBER

Eligible Salary for Option 1
OPT1_TOT_COMP_VAL NUMBER

Total Compensation for Option 1
OPT1_OTH_COMP_VAL NUMBER

Other Compensation for Option 1
OPT1_WS_VAL NUMBER

Worksheet Salary for Option 1
OPT1_WS_MIN_VAL NUMBER

Worksheet minimum value for option 1
OPT1_WS_MAX_VAL NUMBER

Worksheet maximum value for option 1
OPT1_WS_INCR_VAL NUMBER

Worksheet increment value for option 1
OPT1_REC_VAL NUMBER

Recommended value for option 1
OPT1_REC_MIN_VAL NUMBER

Recommended minimum value for option 1
OPT1_REC_MAX_VAL NUMBER

Recommended maximum value for option 1
OPT1_MISC1_VAL NUMBER

Miscellaneous value 1 for option 1
OPT1_MISC2_VAL NUMBER

Miscellaneous value 2 for option 1
OPT1_MISC3_VAL NUMBER

Miscellaneous value 3 for option 1
OPT1_WS_LAST_UPD_DATE DATE

Date when Option 1 was last updated
OPT1_WS_LAST_UPD_NAME VARCHAR2 (240)
Name of the person who has last updated option 1
OPT2_NAME VARCHAR2 (240)
Name of the Option 2
OPT2_XCHG_RATE NUMBER

Exchange rate defined for Option 2
OPT2_STAT_SAL_VAL NUMBER

Stated salary for option 2
OPT2_ELIG_SAL_VAL NUMBER

Eligible Salary for Option 2
OPT2_TOT_COMP_VAL NUMBER

Total Compensation for Option 2
OPT2_OTH_COMP_VAL NUMBER

Other Compensation for Option 2
OPT2_WS_VAL NUMBER

Worksheet Salary for Option 2
OPT2_WS_MIN_VAL NUMBER

Worksheet minimum value for option 2
OPT2_WS_MAX_VAL NUMBER

Worksheet maximum value for option 2
OPT2_WS_INCR_VAL NUMBER

Worksheet increment value for option 2
OPT2_REC_VAL NUMBER

Recommended value for option 2
OPT2_REC_MIN_VAL NUMBER

Recommended minimum value for option 2
OPT2_REC_MAX_VAL NUMBER

Recommended maximum value for option 2
OPT2_MISC1_VAL NUMBER

Miscellaneous value 1 for option 2
OPT2_MISC2_VAL NUMBER

Miscellaneous value 2 for option 2
OPT2_MISC3_VAL NUMBER

Miscellaneous value 3 for option 2
OPT2_WS_LAST_UPD_DATE DATE

Date when option 2 was last updated
OPT2_WS_LAST_UPD_NAME VARCHAR2 (240)
Name of the person who has last updated option 2
OPT3_NAME VARCHAR2 (240)
Name of the Option 3
OPT3_XCHG_RATE NUMBER

Exchange rate defined for Option 3
OPT3_STAT_SAL_VAL NUMBER

Stated salary for option 3
OPT3_ELIG_SAL_VAL NUMBER

Eligible Salary for Option 3
OPT3_TOT_COMP_VAL NUMBER

Total Compensation for Option 3
OPT3_OTH_COMP_VAL NUMBER

Other Compensation for Option 3
OPT3_WS_VAL NUMBER

Worksheet Salary for Option 3
OPT3_WS_MIN_VAL NUMBER

Worksheet minimum value for option 3
OPT3_WS_MAX_VAL NUMBER

Worksheet maximum value for option 3
OPT3_WS_INCR_VAL NUMBER

Worksheet increment value for option 3
OPT3_REC_VAL NUMBER

Recommended value for option 3
OPT3_REC_MIN_VAL NUMBER

Recommended minimum value for option 3
OPT3_REC_MAX_VAL NUMBER

Recommended maximum value for option 3
OPT3_MISC1_VAL NUMBER

Miscellaneous value 1 for option 3
OPT3_MISC2_VAL NUMBER

Miscellaneous value 2 for option 3
OPT3_MISC3_VAL NUMBER

Miscellaneous value 3 for option 3
OPT3_WS_LAST_UPD_DATE DATE

Date when option 2 was last updated
OPT3_WS_LAST_UPD_NAME VARCHAR2 (240)
Name of the person who has last updated option 3
OPT4_NAME VARCHAR2 (240)
Name of the Option 4
OPT4_XCHG_RATE NUMBER

Exchange rate defined for Option 4
OPT4_STAT_SAL_VAL NUMBER

Stated salary for option 4
OPT4_ELIG_SAL_VAL NUMBER

Eligible Salary for Option 4
OPT4_TOT_COMP_VAL NUMBER

Total Compensation for Option 4
OPT4_OTH_COMP_VAL NUMBER

Other Compensation for Option 4
OPT4_WS_VAL NUMBER

Worksheet Salary for Option 4
OPT4_WS_MIN_VAL NUMBER

Worksheet minimum value for option 4
OPT4_WS_MAX_VAL NUMBER

Worksheet maximum value for option 4
OPT4_WS_INCR_VAL NUMBER

Worksheet increment value for option 4
OPT4_REC_VAL NUMBER

Recommended value for option 4
OPT4_REC_MIN_VAL NUMBER

Recommended minimum value for option 4
OPT4_REC_MAX_VAL NUMBER

Recommended maximum value for option 4
OPT4_MISC1_VAL NUMBER

Miscellaneous value 1 for option 4
OPT4_MISC2_VAL NUMBER

Miscellaneous value 2 for option 4
OPT4_MISC3_VAL NUMBER

Miscellaneous value 3 for option 4
OPT4_WS_LAST_UPD_DATE DATE

Date when option 4 was last updated
OPT4_WS_LAST_UPD_NAME VARCHAR2 (240)
Name of the person who has last updated option 4
EMPLOYEE_NUMBER VARCHAR2 (30)
Employee Number
EMP_CATEGORY VARCHAR2 (80)
Employment Category
ASSIGNMENT_STATUS VARCHAR2 (80)
Assignment Status
PEOPLE_GROUP_NAME VARCHAR2 (240)
People Group
EMAIL_ADDR VARCHAR2 (240)
Email Address
START_DATE DATE

Start Date
ORIGINAL_START_DATE DATE

Original Start Date
NORMAL_HOURS NUMBER

Normal Working Hours
PAYROLL_NAME VARCHAR2 (80)
Payroll name
BUSINESS_GROUP_NAME VARCHAR2 (240)
Business Group Name
ORG_NAME VARCHAR2 (240)
Organization Name
LOC_NAME VARCHAR2 (240)
Location
JOB_NAME VARCHAR2 (700)
Job
POS_NAME VARCHAR2 (240)
Position
GRD_NAME VARCHAR2 (240)
Grade
COUNTRY VARCHAR2 (30)
Country
YEARS_IN_JOB NUMBER

Years in Job
YEARS_IN_POSITION NUMBER

Years in Position
YEARS_IN_GRADE NUMBER

Years in Grade
GRADE_RANGE VARCHAR2 (39)
Grade Range
GRADE_MID_POINT NUMBER

Grade mid point
GRD_QUARTILE VARCHAR2 (80)
Grade Quartile
GRD_COMPARATIO NUMBER

Grade Comparatio
PERFORMANCE_RATING VARCHAR2 (80)
Performance rating
PERFORMANCE_RATING_TYPE VARCHAR2 (80)
Rating Type
PERFORMANCE_RATING_DATE DATE

Performance rating date
LAST_RANK NUMBER

Last Rank
LAST_MGR_NAME VARCHAR2 (240)
Last Manager Name
RANK_QUARTILE NUMBER

Rank Quartile
TOTAL_RANK NUMBER

Total Rank
CHANGE_REASON VARCHAR2 (80)
Change Reason
BASE_SALARY_CHANGE_DATE DATE

Change date of Base salary
LF_EVT_OCRD_DT DATE
Yes Life event occurred date.
MGR_LER_ID NUMBER (15) Yes Manager LER Id
PL_PERSON_RATE_ID VARCHAR2 (4000)
Person Rate Id for Plan
P_OPT1_PERSON_RATE_ID VARCHAR2 (4000)
Person Rate Id for Option 1
P_OPT2_PERSON_RATE_ID VARCHAR2 (4000)
Person Rate Id for Option 2
P_OPT3_PERSON_RATE_ID VARCHAR2 (4000)
Person Rate Id for Option 3
P_OPT4_PERSON_RATE_ID VARCHAR2 (4000)
Person Rate Id for Option 4
LVL_NUM NUMBER (15) Yes Hierarchy Level Number
CUSTOM_SEGMENT1 VARCHAR2 (4000)
Descriptive Flexfield segment column
CUSTOM_SEGMENT2 VARCHAR2 (4000)
Descriptive Flexfield segment column
CUSTOM_SEGMENT3 VARCHAR2 (4000)
Descriptive Flexfield segment column
CUSTOM_SEGMENT4 VARCHAR2 (4000)
Descriptive Flexfield segment column
CUSTOM_SEGMENT5 VARCHAR2 (4000)
Descriptive Flexfield segment column
CUSTOM_SEGMENT6 VARCHAR2 (4000)
Descriptive Flexfield segment column
CUSTOM_SEGMENT7 VARCHAR2 (4000)
Descriptive Flexfield segment column
CUSTOM_SEGMENT8 VARCHAR2 (4000)
Descriptive Flexfield segment column
CUSTOM_SEGMENT9 VARCHAR2 (4000)
Descriptive Flexfield segment column
CUSTOM_SEGMENT10 VARCHAR2 (4000)
Descriptive Flexfield segment column
CUSTOM_SEGMENT11 NUMBER

Descriptive Flexfield segment column
CUSTOM_SEGMENT12 NUMBER

Descriptive Flexfield segment column
CUSTOM_SEGMENT13 NUMBER

Descriptive Flexfield segment column
CUSTOM_SEGMENT14 NUMBER

Descriptive Flexfield segment column
CUSTOM_SEGMENT15 NUMBER

Descriptive Flexfield segment column
PROPOSED_PERFORMANCE_RATING VARCHAR2 (4000)
Proposed performance rating
PROPOSED_JOB VARCHAR2 (700)
Proposed Job
PLAN_UOM VARCHAR2 (4000)
Unit of measure for plan
OPT1_UOM VARCHAR2 (4000)
Unit of measure for Option 1
OPT2_UOM VARCHAR2 (4000)
Unit of measure for Option 2
OPT3_UOM VARCHAR2 (4000)
Unit of measure for Option 3
OPT4_UOM VARCHAR2 (4000)
Unit of measure for Option 4
PROPOSED_GRADE VARCHAR2 (240)
Proposed Grade
PROPOSED_POSITION VARCHAR2 (240)
Proposed Position
PROPOSED_GROUP VARCHAR2 (0)
Proposed Group
CPI_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield context
CPI_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE21 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE22 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE23 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE24 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE25 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE26 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE27 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE28 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE29 VARCHAR2 (150)
Descriptive flexfield segment column
CPI_ATTRIBUTE30 VARCHAR2 (150)
Descriptive flexfield segment column
CUSTOM_SEGMENT16 NUMBER

Descriptive flexfield segment column
CUSTOM_SEGMENT17 NUMBER

Descriptive flexfield segment column
CUSTOM_SEGMENT18 NUMBER

Descriptive flexfield segment column
CUSTOM_SEGMENT19 NUMBER

Descriptive flexfield segment column
CUSTOM_SEGMENT20 NUMBER

Descriptive flexfield segment column
PL_CURRENCY VARCHAR2 (30)
Plan Currency
OPT1_CURRENCY VARCHAR2 (30)
Option 1 currency
OPT2_CURRENCY VARCHAR2 (30)
Option 2 currency
OPT3_CURRENCY VARCHAR2 (30)
Option 3 currency
OPT4_CURRENCY VARCHAR2 (30)
Option 4 currency
PL_WS_RT_START_DATE DATE

Worksheet rate start date for plan
OPT1_WS_RT_START_DATE DATE

Worksheet rate start date for Option 1
OPT2_WS_RT_START_DATE DATE

Worksheet rate start date for Option 2
OPT3_WS_RT_START_DATE DATE

Worksheet rate start date for Option 3
OPT4_WS_RT_START_DATE DATE

Worksheet rate start date for Option 4
PROPOSED_GRADE_RANGE VARCHAR2 (4000)
Proposed Grade Range
PROPOSED_GRADE_MID_POINT NUMBER

Proposed Grade Mid Point
PROPOSED_GRD_COMPARATIO NUMBER

Proposed Grd Comparatio
Query Text

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


SELECT EMP_NAME
,      MGR_NAME
,      RANK
,      YEARS_EMPLOYED
,      BASE_SALARY
,      PL_NAME
,      PL_XCHG_RATE
,      PL_STAT_SAL_VAL
,      PL_ELIG_SAL_VAL
,      PL_TOT_COMP_VAL
,      PL_OTH_COMP_VAL
,      PL_WS_VAL
,      PL_WS_MIN_VAL
,      PL_WS_MAX_VAL
,      PL_WS_INCR_VAL
,      PL_REC_VAL
,      PL_REC_MIN_VAL
,      PL_REC_MAX_VAL
,      PL_MISC1_VAL
,      PL_MISC2_VAL
,      PL_MISC3_VAL
,      PL_WS_LAST_UPD_DATE
,      PL_WS_LAST_UPD_NAME
,      OPT1_NAME
,      OPT1_XCHG_RATE
,      OPT1_STAT_SAL_VAL
,      OPT1_ELIG_SAL_VAL
,      OPT1_TOT_COMP_VAL
,      OPT1_OTH_COMP_VAL
,      OPT1_WS_VAL
,      OPT1_WS_MIN_VAL
,      OPT1_WS_MAX_VAL
,      OPT1_WS_INCR_VAL
,      OPT1_REC_VAL
,      OPT1_REC_MIN_VAL
,      OPT1_REC_MAX_VAL
,      OPT1_MISC1_VAL
,      OPT1_MISC2_VAL
,      OPT1_MISC3_VAL
,      OPT1_WS_LAST_UPD_DATE
,      OPT1_WS_LAST_UPD_NAME
,      OPT2_NAME
,      OPT2_XCHG_RATE
,      OPT2_STAT_SAL_VAL
,      OPT2_ELIG_SAL_VAL
,      OPT2_TOT_COMP_VAL
,      OPT2_OTH_COMP_VAL
,      OPT2_WS_VAL
,      OPT2_WS_MIN_VAL
,      OPT2_WS_MAX_VAL
,      OPT2_WS_INCR_VAL
,      OPT2_REC_VAL
,      OPT2_REC_MIN_VAL
,      OPT2_REC_MAX_VAL
,      OPT2_MISC1_VAL
,      OPT2_MISC2_VAL
,      OPT2_MISC3_VAL
,      OPT2_WS_LAST_UPD_DATE
,      OPT2_WS_LAST_UPD_NAME
,      OPT3_NAME
,      OPT3_XCHG_RATE
,      OPT3_STAT_SAL_VAL
,      OPT3_ELIG_SAL_VAL
,      OPT3_TOT_COMP_VAL
,      OPT3_OTH_COMP_VAL
,      OPT3_WS_VAL
,      OPT3_WS_MIN_VAL
,      OPT3_WS_MAX_VAL
,      OPT3_WS_INCR_VAL
,      OPT3_REC_VAL
,      OPT3_REC_MIN_VAL
,      OPT3_REC_MAX_VAL
,      OPT3_MISC1_VAL
,      OPT3_MISC2_VAL
,      OPT3_MISC3_VAL
,      OPT3_WS_LAST_UPD_DATE
,      OPT3_WS_LAST_UPD_NAME
,      OPT4_NAME
,      OPT4_XCHG_RATE
,      OPT4_STAT_SAL_VAL
,      OPT4_ELIG_SAL_VAL
,      OPT4_TOT_COMP_VAL
,      OPT4_OTH_COMP_VAL
,      OPT4_WS_VAL
,      OPT4_WS_MIN_VAL
,      OPT4_WS_MAX_VAL
,      OPT4_WS_INCR_VAL
,      OPT4_REC_VAL
,      OPT4_REC_MIN_VAL
,      OPT4_REC_MAX_VAL
,      OPT4_MISC1_VAL
,      OPT4_MISC2_VAL
,      OPT4_MISC3_VAL
,      OPT4_WS_LAST_UPD_DATE
,      OPT4_WS_LAST_UPD_NAME
,      EMPLOYEE_NUMBER
,      EMP_CATEGORY
,      ASSIGNMENT_STATUS
,      PEOPLE_GROUP_NAME
,      EMAIL_ADDR
,      START_DATE
,      ORIGINAL_START_DATE
,      NORMAL_HOURS
,      PAYROLL_NAME
,      BUSINESS_GROUP_NAME
,      ORG_NAME
,      LOC_NAME
,      JOB_NAME
,      POS_NAME
,      GRD_NAME
,      COUNTRY
,      YEARS_IN_JOB
,      YEARS_IN_POSITION
,      YEARS_IN_GRADE
,      GRADE_RANGE
,      GRADE_MID_POINT
,      GRD_QUARTILE
,      GRD_COMPARATIO
,      PERFORMANCE_RATING
,      PERFORMANCE_RATING_TYPE
,      PERFORMANCE_RATING_DATE
,      LAST_RANK
,      LAST_MGR_NAME
,      RANK_QUARTILE
,      TOTAL_RANK
,      CHANGE_REASON
,      BASE_SALARY_CHANGE_DATE
,      LF_EVT_OCRD_DT
,      MGR_LER_ID
,      PL_PERSON_RATE_ID
,      P_OPT1_PERSON_RATE_ID
,      P_OPT2_PERSON_RATE_ID
,      P_OPT3_PERSON_RATE_ID
,      P_OPT4_PERSON_RATE_ID
,      LVL_NUM
,      CUSTOM_SEGMENT1
,      CUSTOM_SEGMENT2
,      CUSTOM_SEGMENT3
,      CUSTOM_SEGMENT4
,      CUSTOM_SEGMENT5
,      CUSTOM_SEGMENT6
,      CUSTOM_SEGMENT7
,      CUSTOM_SEGMENT8
,      CUSTOM_SEGMENT9
,      CUSTOM_SEGMENT10
,      CUSTOM_SEGMENT11
,      CUSTOM_SEGMENT12
,      CUSTOM_SEGMENT13
,      CUSTOM_SEGMENT14
,      CUSTOM_SEGMENT15
,      PROPOSED_PERFORMANCE_RATING
,      PROPOSED_JOB
,      PLAN_UOM
,      OPT1_UOM
,      OPT2_UOM
,      OPT3_UOM
,      OPT4_UOM
,      PROPOSED_GRADE
,      PROPOSED_POSITION
,      PROPOSED_GROUP
,      CPI_ATTRIBUTE_CATEGORY
,      CPI_ATTRIBUTE1
,      CPI_ATTRIBUTE2
,      CPI_ATTRIBUTE3
,      CPI_ATTRIBUTE4
,      CPI_ATTRIBUTE5
,      CPI_ATTRIBUTE6
,      CPI_ATTRIBUTE7
,      CPI_ATTRIBUTE8
,      CPI_ATTRIBUTE9
,      CPI_ATTRIBUTE10
,      CPI_ATTRIBUTE11
,      CPI_ATTRIBUTE12
,      CPI_ATTRIBUTE13
,      CPI_ATTRIBUTE14
,      CPI_ATTRIBUTE15
,      CPI_ATTRIBUTE16
,      CPI_ATTRIBUTE17
,      CPI_ATTRIBUTE18
,      CPI_ATTRIBUTE19
,      CPI_ATTRIBUTE20
,      CPI_ATTRIBUTE21
,      CPI_ATTRIBUTE22
,      CPI_ATTRIBUTE23
,      CPI_ATTRIBUTE24
,      CPI_ATTRIBUTE25
,      CPI_ATTRIBUTE26
,      CPI_ATTRIBUTE27
,      CPI_ATTRIBUTE28
,      CPI_ATTRIBUTE29
,      CPI_ATTRIBUTE30
,      CUSTOM_SEGMENT16
,      CUSTOM_SEGMENT17
,      CUSTOM_SEGMENT18
,      CUSTOM_SEGMENT19
,      CUSTOM_SEGMENT20
,      PL_CURRENCY
,      OPT1_CURRENCY
,      OPT2_CURRENCY
,      OPT3_CURRENCY
,      OPT4_CURRENCY
,      PL_WS_RT_START_DATE
,      OPT1_WS_RT_START_DATE
,      OPT2_WS_RT_START_DATE
,      OPT3_WS_RT_START_DATE
,      OPT4_WS_RT_START_DATE
,      PROPOSED_GRADE_RANGE
,      PROPOSED_GRADE_MID_POINT
,      PROPOSED_GRD_COMPARATIO
FROM APPS.BEN_CWB_WS_DOWNLOAD_V;

Dependencies

[top of page]

APPS.BEN_CWB_WS_DOWNLOAD_V references the following:

SchemaAPPS
PL/SQL PackageBENUTILS - show dependent code
SynonymBEN_CWB_GROUP_HRCHY
SynonymBEN_CWB_PERSON_INFO
SynonymBEN_CWB_PERSON_RATES
SynonymBEN_CWB_PL_DSGN
PL/SQL PackageBEN_CWB_UTILS - show dependent code
PL/SQL PackageBEN_CWB_WEBADI_UTILS - show dependent code
SynonymBEN_CWB_XCHG
SynonymBEN_TRANSACTION
SynonymFND_CURRENCIES
PL/SQL PackageFND_PROFILE - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_ALL_POSITIONS_F_TL
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL_TL
ViewHR_LOOKUPS
SynonymPER_ALL_PEOPLE_F
SynonymPER_ASSIGNMENT_EXTRA_INFO
SynonymPER_ASSIGNMENT_STATUS_TYPES_TL
SynonymPER_GRADES_TL
SynonymPER_JOBS_TL

APPS.BEN_CWB_WS_DOWNLOAD_V is not referenced by any database object