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_EQUITY_EDGE_ACT_INFO_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LAST_NAME	VARCHAR2	(150)	Yes	Employee Last Name.
FIRST_NAME	VARCHAR2	(150)		Employee First Name.
MIDDLE_NAME	VARCHAR2	(60)		Employee Middle Name.
EMPLOYEE_NUMBER	VARCHAR2	(30)		Employee Number.
SSN	VARCHAR2	(30)		National Identifier.
ADDRESS_LINE1	VARCHAR2	(240)		Address Line 1.
ADDRESS_LINE2	VARCHAR2	(240)		Address Line 2.
ADDRESS_LINE3	VARCHAR2	(240)		Address Line 3.
US_CITY_OR_INTNL_ADDR	VARCHAR2	(428)		US City Name or International Address.
US_STATE	VARCHAR2	(120)		US State.
EMP_ADDR_COUNTRY	VARCHAR2	(60)		Country Employee Resides.
US_ZIP_CODE	VARCHAR2	(30)		Postal Code.
TITLE_1	VARCHAR2	(30)		Title.
TITLE_2	VARCHAR2	(30)		Secondary Title.
BUS_GRP_COUNTRY	VARCHAR2	(150)		Country where company is based.
ORG_NAME	VARCHAR2	(240)		Organization Name.
USR_DFND_3	NUMBER	(15)	Yes	User defined field.
PERSON_ID	NUMBER	(10)	Yes	Foreign Key to PER_PEOPLE_F.
WS_MGR_FULL_NAME	VARCHAR2	(240)		Manager Full Name.
USR_DFND_6	VARCHAR2	(0)		User defined Field.
EMPLOYEE_FLAG	CHAR	(1)		Employee Flag.
HIRE_DATE	DATE		Yes	Employees Hire Date.
EMAIL	VARCHAR2	(240)		Email address.
DIRECTOR_FLAG	VARCHAR2	(0)		Company Director [Y/N].
OFFICER_FLAG	VARCHAR2	(0)		Company Officer [Y/N].
TEN_PCT_OWNER_FLAG	VARCHAR2	(0)		Company Owner [Y/N].
OTH_INSIDER_FLAG	VARCHAR2	(0)		Company Insider [Y/N].
ENRT_PERD_ID	NUMBER	(15)		Identifier of the Enrollment Period.
BIND_PERSON_ID	NUMBER	(10)	Yes	Person Identifier.

Query Text

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


SELECT LAST_NAME
,      FIRST_NAME
,      MIDDLE_NAME
,      EMPLOYEE_NUMBER
,      SSN
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      US_CITY_OR_INTNL_ADDR
,      US_STATE
,      EMP_ADDR_COUNTRY
,      US_ZIP_CODE
,      TITLE_1
,      TITLE_2
,      BUS_GRP_COUNTRY
,      ORG_NAME
,      USR_DFND_3
,      PERSON_ID
,      WS_MGR_FULL_NAME
,      USR_DFND_6
,      EMPLOYEE_FLAG
,      HIRE_DATE
,      EMAIL
,      DIRECTOR_FLAG
,      OFFICER_FLAG
,      TEN_PCT_OWNER_FLAG
,      OTH_INSIDER_FLAG
,      ENRT_PERD_ID
,      BIND_PERSON_ID
FROM APPS.BEN_CWB_EQUITY_EDGE_ACT_INFO_V;

Dependencies

[top of page]

APPS.BEN_CWB_EQUITY_EDGE_ACT_INFO_V references the following:

APPS: BEN_ELIG_PER_ELCTBL_CHC; BEN_ENRT_RT; BEN_PER_IN_LER; BEN_PIL_ELCTBL_CHC_POPL; BEN_PRTT_RT_VAL; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code; PER_ADDRESSES; PER_ALL_ASSIGNMENTS_F; PER_ALL_PEOPLE_F; PER_BUSINESS_GROUPS_PERF; PER_JOBS

APPS.BEN_CWB_EQUITY_EDGE_ACT_INFO_V is not referenced by any database object