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_REPT_COMP_COMPARISON_V

Object Details

Object Name:	BEN_CWB_REPT_COMP_COMPARISON_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BEN.BEN_CWB_REPT_COMP_COMPARISON_V
Subobject Name:
Status:	VALID

View Type

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

BEN_CWB_REPT_COMP_COMPARISON_V contains a comparison of the compensation plan status across managers.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ASND_LF_EVT_DT	DATE			Assigned Date.
MANAGER_NAME	VARCHAR2	(332)		Manager Name.
MANAGER_FULL_NAME	VARCHAR2	(240)		Manager Full Name.
PLAN_NAME	VARCHAR2	(482)		Plan Name.
COUNTRY	VARCHAR2	(150)		Country.
ELIGIBLE_EMPLOYEES	NUMBER			Number of Eligible Employees.
ELIGIBLE_EMPS_W_VAL	NUMBER			Eligible Employees with Value.
PCT_W_VAL	NUMBER			Percentage of Employees with Value.
TOTAL_ALLOCATED	NUMBER			Total Allocated.
UNITS	VARCHAR2	(80)		Allocation Unit of Measure.
AVERAGE_ALLOCATED	NUMBER			Average number Allocated.
BUDGET	NUMBER			Budget Amount.
UNUSED_BUDGET	NUMBER			Amount of Budget Unused.
MANAGER_ID	NUMBER	(15)	Yes	Manager Identifier.
ENRT_PERD_ID	NUMBER	(15)	Yes	Enrollment Period Identifier.

Query Text

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


SELECT ASND_LF_EVT_DT
,      MANAGER_NAME
,      MANAGER_FULL_NAME
,      PLAN_NAME
,      COUNTRY
,      ELIGIBLE_EMPLOYEES
,      ELIGIBLE_EMPS_W_VAL
,      PCT_W_VAL
,      TOTAL_ALLOCATED
,      UNITS
,      AVERAGE_ALLOCATED
,      BUDGET
,      UNUSED_BUDGET
,      MANAGER_ID
,      ENRT_PERD_ID
FROM APPS.BEN_CWB_REPT_COMP_COMPARISON_V;

Dependencies

[top of page]

APPS.BEN_CWB_REPT_COMP_COMPARISON_V references the following:

APPS: BEN_ACTY_BASE_RT_F; BEN_CWB_HRCHY; BEN_ELIG_PER_ELCTBL_CHC; BEN_ENRT_PERD; BEN_ENRT_RT; BEN_OIPL_F; BEN_OPT_F; BEN_PER_IN_LER; BEN_PIL_ELCTBL_CHC_POPL; BEN_PL_F; FND_GLOBAL - show dependent code; HR_API - show dependent code; HR_LOOKUPS; PER_ALL_PEOPLE_F; PER_BUSINESS_GROUPS_PERF

APPS.BEN_CWB_REPT_COMP_COMPARISON_V is referenced by following:

PUBLIC: BEN_CWB_REPT_COMP_COMPARISON_V