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


VIEW: APPS.HR_ATH_EMPGROUP_V

Object Details
Object Name: HR_ATH_EMPGROUP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_ATH_EMPGROUP_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View to support Authoria Integration


[View Source]

Columns
Name Datatype Length Mandatory Comments
EMPLOYEE_GROUPID VARCHAR2 (40)
fk to hr_organization_units
NAME VARCHAR2 (240) Yes group name
START_DATE DATE
Yes start date for this group
END_DATE DATE

end date for this group
Query Text

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


SELECT EMPLOYEE_GROUPID
,      NAME
,      START_DATE
,      END_DATE
FROM APPS.HR_ATH_EMPGROUP_V;

Dependencies

[top of page]

APPS.HR_ATH_EMPGROUP_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_ORGANIZATION_INFORMATION
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code

APPS.HR_ATH_EMPGROUP_V is not referenced by any database object