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


VIEW: APPS.PA_EMPLOYEES_ADMIN_V

Object Details
Object Name: PA_EMPLOYEES_ADMIN_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_EMPLOYEES_ADMIN_V
Subobject Name:
Status: VALID

View Type

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


This view displays a list of valid employees.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (10) Yes Person Id.
EMPLOYEE_NAME VARCHAR2 (240)
Full Name: Last, First Middle
EMPLOYEE_NUMBER VARCHAR2 (30)
Employee Number
Query Text

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


SELECT PERSON_ID
,      EMPLOYEE_NAME
,      EMPLOYEE_NUMBER
FROM APPS.PA_EMPLOYEES_ADMIN_V;

Dependencies

[top of page]

APPS.PA_EMPLOYEES_ADMIN_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackagePA_ADMIN_EXT - show dependent code
ViewPER_PEOPLE_F

APPS.PA_EMPLOYEES_ADMIN_V is not referenced by any database object