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

VIEW: APPS.BEN_CWB_STOCK_HIST_DWLD_V

Object Details
Object Name: BEN_CWB_STOCK_HIST_DWLD_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 Stock History download.


[View Source]

Columns
Name Datatype Length Mandatory Comments
GROUP_PL_ID NUMBER (15)
Group Pl Id
LF_EVT_OCRD_DT DATE
Yes Lf Evt Ocrd Dt
MGR_PERSON_ID NUMBER (15) Yes Mgr Person Id
GRANT_NAME VARCHAR2 (4000)
Grant Name
EMPLOYEE_NAME VARCHAR2 (513)
Employee Name
SHARES_GRANTED NUMBER

Shares Granted
GRANT_PRICE NUMBER

Grant Price
SHARES_VESTED NUMBER

Shares Vested
SHARES_UNVESTED NUMBER

Shares Unvested
WALK_AWAY NUMBER

Walk Away
PERSON_ID NUMBER (15) Yes Person Id
Query Text

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


SELECT GROUP_PL_ID
,      LF_EVT_OCRD_DT
,      MGR_PERSON_ID
,      GRANT_NAME
,      EMPLOYEE_NAME
,      SHARES_GRANTED
,      GRANT_PRICE
,      SHARES_VESTED
,      SHARES_UNVESTED
,      WALK_AWAY
,      PERSON_ID
FROM APPS.BEN_CWB_STOCK_HIST_DWLD_V;

Dependencies

[top of page]

APPS.BEN_CWB_STOCK_HIST_DWLD_V references the following:

SchemaAPPS
SynonymBEN_CWB_GROUP_HRCHY
SynonymBEN_CWB_PERSON_INFO
SynonymBEN_CWB_STOCK_OPTN_DTLS
SynonymBEN_PER_IN_LER
PL/SQL PackageFND_MESSAGE - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code

APPS.BEN_CWB_STOCK_HIST_DWLD_V is not referenced by any database object