[Home] [Help]
[Dependency Information]
| Object Name: | PA_XLA_EMPLOYEE_REF_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PA.PA_XLA_EMPLOYEE_REF_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (10) | ||
| EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
| EMPLOYEE_NAME | VARCHAR2 | (240) | ||
| PERSON_TYPE | VARCHAR2 | (30) | - Person_type | |
| EFFECTIVE_START_DATE | DATE | |||
| EFFECTIVE_END_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, EMPLOYEE_NUMBER
, EMPLOYEE_NAME
, PERSON_TYPE
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
FROM APPS.PA_XLA_EMPLOYEE_REF_V;
APPS
HR_GENERAL
- show dependent code
HR_PERSON_NAME
- show dependent code
HR_SECURITY
- show dependent code
PA_EMPLOYEES
APPS.PA_XLA_EMPLOYEE_REF_V is not referenced by any database object
|
|
|
|