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

VIEW: APPS.BEN_CWB_BDGT_DOWNLOAD_V

Object Details
Object Name: BEN_CWB_BDGT_DOWNLOAD_V
Object Type: VIEW
Owner: APPS
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 Budget sheet download.


[View Source]

Columns
Name Datatype Length Mandatory Comments
GROUP_PL_ID NUMBER (15) Yes Group Plan Id
MGR_PER_IN_LER_ID NUMBER (15) Yes Manager Per In Ler Id
EMPLOYEE_NAME VARCHAR2 (480)
Employee Name
EMPLOYEE_NUMBER VARCHAR2 (30)
Employee Number
JOB VARCHAR2 (700)
Job
ELIG_COUNT_ALL NUMBER

Eligible Count All
ELIG_COUNT_DIRECT NUMBER

Eligibile Count Direct
ELIG_COUNT_INDIRECT NUMBER

Eligibile Count Indirect
ELIG_SAL_VAL NUMBER

Eligible Salary Value
PCT_ELIG_SAL NUMBER

Percentage of Eligible Salary
BDGT_VAL NUMBER

Budget Value
BDGT_UNIT VARCHAR2 (30)
Budget Unit
ISS_BDGT_VAL NUMBER

Issued Budget Value
STAT_SAL_VAL NUMBER

Stated Salary Value
TOT_COMP_VAL NUMBER

Total Compensation Value
OTH_COMP_VAL NUMBER

Other Compensation Value
MISC1_VAL NUMBER

Miscellaneous1 Value
MISC2_VAL NUMBER

Miscellaneous2 Value
MISC3_VAL NUMBER

Miscellaneous3 Value
REC_VAL NUMBER

Recommended Value
REC_MN_VAL NUMBER

Recommended Min Value
REC_MX_VAL NUMBER

Recommended Max Value
BDGT_ISS_DATE DATE

Budget Issue Date
OPT1_ELIG_COUNT_ALL NUMBER

Eligible Count All (Option 1)
OPT1_ELIG_COUNT_DIRECT NUMBER

Eligible Count Direct (Option 1)
OPT1_ELIG_COUNT_INDIRECT NUMBER

Eligible Count Indirect (Option 1)
OPT1_ELIG_SAL_VAL NUMBER

Eligible Salary Value (Option 1)
OPT1_PCT_ELIG_SAL NUMBER

Percentage of Eligible Salary (Option 1)
OPT1_BDGT_VAL NUMBER

Budget Value (Option 1)
OPT1_BDGT_UNIT VARCHAR2 (30)
Budget Unit (Option 1)
OPT1_ISS_BDGT_VAL NUMBER

Issue Budget Value (Option 1)
OPT1_STAT_SAL_VAL NUMBER

Stated Salary Value (Option 1)
OPT1_TOT_COMP_VAL NUMBER

Total Compensation Value (Option 1)
OPT1_OTH_COMP_VAL NUMBER

Other Compensation Value (Option 1)
OPT1_MISC1_VAL NUMBER

Miscellaneous1 Value (Option 1)
OPT1_MISC2_VAL NUMBER

Miscellaneous2 Value (Option 1)
OPT1_MISC3_VAL NUMBER

Miscellaneous3 Value (Option 1)
OPT1_REC_VAL NUMBER

Recommended Value (Option 1)
OPT1_REC_MN_VAL NUMBER

Recommended Min Value (Option 1)
OPT1_REC_MX_VAL NUMBER

Recommended Max Value (Option 1)
OPT2_ELIG_COUNT_ALL NUMBER

Eligible Count All (Option 2)
OPT2_ELIG_COUNT_DIRECT NUMBER

Eligible Count Direct (Option 2)
OPT2_ELIG_COUNT_INDIRECT NUMBER

Eligible Count Indirect (Option 2)
OPT2_ELIG_SAL_VAL NUMBER

Eligible Salary Value (Option 2)
OPT2_PCT_ELIG_SAL NUMBER

Percentage of Eligible Salary (Option 2)
OPT2_BDGT_VAL NUMBER

Budget Value (Option 2)
OPT2_BDGT_UNIT VARCHAR2 (30)
Budget Unit (Option 2)
OPT2_ISS_BDGT_VAL NUMBER

Issue Budget Value (Option 2)
OPT2_STAT_SAL_VAL NUMBER

Stated Salary Value (Option 2)
OPT2_TOT_COMP_VAL NUMBER

Total Compensation Value (Option 2)
OPT2_OTH_COMP_VAL NUMBER

Other Compensation Value (Option 2)
OPT2_MISC1_VAL NUMBER

Miscellaneous1 Value (Option 2)
OPT2_MISC2_VAL NUMBER

Miscellaneous2 Value (Option 2)
OPT2_MISC3_VAL NUMBER

Miscellaneous3 Value (Option 2)
OPT2_REC_VAL NUMBER

Recommended Value (Option 2)
OPT2_REC_MN_VAL NUMBER

Recommended Min Value (Option 2)
OPT2_REC_MX_VAL NUMBER

Recommended Max Value (Option 2)
OPT3_ELIG_COUNT_ALL NUMBER

Eligible Count All (Option 3)
OPT3_ELIG_COUNT_DIRECT NUMBER

Eligible Count Direct (Option 3)
OPT3_ELIG_COUNT_INDIRECT NUMBER

Eligible Count Indirect (Option 3)
OPT3_ELIG_SAL_VAL NUMBER

Eligible Salary Value (Option 3)
OPT3_PCT_ELIG_SAL NUMBER

Percentage of Eligible Salary (Option 3)
OPT3_BDGT_VAL NUMBER

Budget Value (Option 3)
OPT3_BDGT_UNIT VARCHAR2 (30)
Budget Unit (Option 3)
OPT3_ISS_BDGT_VAL NUMBER

Issue Budget Value (Option 3)
OPT3_STAT_SAL_VAL NUMBER

Stated Salary Value (Option 3)
OPT3_TOT_COMP_VAL NUMBER

Total Compensation Value (Option 3)
OPT3_OTH_COMP_VAL NUMBER

Other Compensation Value (Option 3)
OPT3_MISC1_VAL NUMBER

Miscellaneous1 Value (Option 3)
OPT3_MISC2_VAL NUMBER

Miscellaneous2 Value (Option 3)
OPT3_MISC3_VAL NUMBER

Miscellaneous3 Value (Option 3)
OPT3_REC_VAL NUMBER

Recommended Value (Option 3)
OPT3_REC_MN_VAL NUMBER

Recommended Min Value (Option 3)
OPT3_REC_MX_VAL NUMBER

Recommended Max Value (Option 3)
OPT4_ELIG_COUNT_ALL NUMBER

Eligible Count All (Option 4)
OPT4_ELIG_COUNT_DIRECT NUMBER

Eligible Count Direct (Option 4)
OPT4_ELIG_COUNT_INDIRECT NUMBER

Eligible Count Indirect (Option 4)
OPT4_ELIG_SAL_VAL NUMBER

Eligible Salary Value (Option 4)
OPT4_PCT_ELIG_SAL NUMBER

Percentage of Eligible Salary (Option 4)
OPT4_BDGT_VAL NUMBER

Budget Value (Option 4)
OPT4_BDGT_UNIT VARCHAR2 (30)
Budget Unit (Option 4)
OPT4_ISS_BDGT_VAL NUMBER

Issue Budget Value (Option 4)
OPT4_STAT_SAL_VAL NUMBER

Stated Salary Value (Option 4)
OPT4_TOT_COMP_VAL NUMBER

Total Compensation Value (Option 4)
OPT4_OTH_COMP_VAL NUMBER

Other Compensation Value (Option 4)
OPT4_MISC1_VAL NUMBER

Miscellaneous1 Value (Option 4)
OPT4_MISC2_VAL NUMBER

Miscellaneous2 Value (Option 4)
OPT4_MISC3_VAL NUMBER

Miscellaneous3 Value (Option 4)
OPT4_REC_VAL NUMBER

Recommended Value (Option 4)
OPT4_REC_MN_VAL NUMBER

Recommended Min Value (Option 4)
OPT4_REC_MX_VAL NUMBER

Recommended Max Value (Option 4)
Query Text

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


SELECT GROUP_PL_ID
,      MGR_PER_IN_LER_ID
,      EMPLOYEE_NAME
,      EMPLOYEE_NUMBER
,      JOB
,      ELIG_COUNT_ALL
,      ELIG_COUNT_DIRECT
,      ELIG_COUNT_INDIRECT
,      ELIG_SAL_VAL
,      PCT_ELIG_SAL
,      BDGT_VAL
,      BDGT_UNIT
,      ISS_BDGT_VAL
,      STAT_SAL_VAL
,      TOT_COMP_VAL
,      OTH_COMP_VAL
,      MISC1_VAL
,      MISC2_VAL
,      MISC3_VAL
,      REC_VAL
,      REC_MN_VAL
,      REC_MX_VAL
,      BDGT_ISS_DATE
,      OPT1_ELIG_COUNT_ALL
,      OPT1_ELIG_COUNT_DIRECT
,      OPT1_ELIG_COUNT_INDIRECT
,      OPT1_ELIG_SAL_VAL
,      OPT1_PCT_ELIG_SAL
,      OPT1_BDGT_VAL
,      OPT1_BDGT_UNIT
,      OPT1_ISS_BDGT_VAL
,      OPT1_STAT_SAL_VAL
,      OPT1_TOT_COMP_VAL
,      OPT1_OTH_COMP_VAL
,      OPT1_MISC1_VAL
,      OPT1_MISC2_VAL
,      OPT1_MISC3_VAL
,      OPT1_REC_VAL
,      OPT1_REC_MN_VAL
,      OPT1_REC_MX_VAL
,      OPT2_ELIG_COUNT_ALL
,      OPT2_ELIG_COUNT_DIRECT
,      OPT2_ELIG_COUNT_INDIRECT
,      OPT2_ELIG_SAL_VAL
,      OPT2_PCT_ELIG_SAL
,      OPT2_BDGT_VAL
,      OPT2_BDGT_UNIT
,      OPT2_ISS_BDGT_VAL
,      OPT2_STAT_SAL_VAL
,      OPT2_TOT_COMP_VAL
,      OPT2_OTH_COMP_VAL
,      OPT2_MISC1_VAL
,      OPT2_MISC2_VAL
,      OPT2_MISC3_VAL
,      OPT2_REC_VAL
,      OPT2_REC_MN_VAL
,      OPT2_REC_MX_VAL
,      OPT3_ELIG_COUNT_ALL
,      OPT3_ELIG_COUNT_DIRECT
,      OPT3_ELIG_COUNT_INDIRECT
,      OPT3_ELIG_SAL_VAL
,      OPT3_PCT_ELIG_SAL
,      OPT3_BDGT_VAL
,      OPT3_BDGT_UNIT
,      OPT3_ISS_BDGT_VAL
,      OPT3_STAT_SAL_VAL
,      OPT3_TOT_COMP_VAL
,      OPT3_OTH_COMP_VAL
,      OPT3_MISC1_VAL
,      OPT3_MISC2_VAL
,      OPT3_MISC3_VAL
,      OPT3_REC_VAL
,      OPT3_REC_MN_VAL
,      OPT3_REC_MX_VAL
,      OPT4_ELIG_COUNT_ALL
,      OPT4_ELIG_COUNT_DIRECT
,      OPT4_ELIG_COUNT_INDIRECT
,      OPT4_ELIG_SAL_VAL
,      OPT4_PCT_ELIG_SAL
,      OPT4_BDGT_VAL
,      OPT4_BDGT_UNIT
,      OPT4_ISS_BDGT_VAL
,      OPT4_STAT_SAL_VAL
,      OPT4_TOT_COMP_VAL
,      OPT4_OTH_COMP_VAL
,      OPT4_MISC1_VAL
,      OPT4_MISC2_VAL
,      OPT4_MISC3_VAL
,      OPT4_REC_VAL
,      OPT4_REC_MN_VAL
,      OPT4_REC_MX_VAL
FROM APPS.BEN_CWB_BDGT_DOWNLOAD_V;

Dependencies

[top of page]

APPS.BEN_CWB_BDGT_DOWNLOAD_V references the following:

SchemaAPPS
SynonymBEN_CWB_GROUP_HRCHY
SynonymBEN_CWB_PERSON_GROUPS
SynonymBEN_CWB_PERSON_INFO
SynonymBEN_CWB_PL_DSGN
SynonymBEN_CWB_SUMMARY
PL/SQL PackageFND_PROFILE - show dependent code
SynonymPER_JOBS_TL

APPS.BEN_CWB_BDGT_DOWNLOAD_V is not referenced by any database object