eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:

APPS: BEN_CWB_GROUP_HRCHY; BEN_CWB_PERSON_GROUPS; BEN_CWB_PERSON_INFO; BEN_CWB_PL_DSGN; BEN_CWB_SUMMARY; FND_PROFILE - show dependent code; PER_JOBS_TL

APPS.BEN_CWB_BDGT_DOWNLOAD_V is not referenced by any database object