[Home] [Help]
[Dependency Information]
VIEW: APPS.PA_EMPLOYEES
Object Details
Object Name: | PA_EMPLOYEES |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_EMPLOYEES
|
---|
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 |
PERSON_ID |
NUMBER |
(10) |
|
|
FULL_NAME |
VARCHAR2 |
(240) |
|
|
EMPLOYEE_NUMBER |
VARCHAR2 |
(30) |
|
|
LAST_NAME |
VARCHAR2 |
(150) |
|
|
FIRST_NAME |
VARCHAR2 |
(150) |
|
|
MIDDLE_NAMES |
VARCHAR2 |
(60) |
|
|
EFFECTIVE_START_DATE |
DATE |
|
|
|
EFFECTIVE_END_DATE |
DATE |
|
|
|
EXPENSE_CHECK_SEND_TO_ADDRESS |
VARCHAR2 |
(30) |
|
|
BUSINESS_GROUP_ID |
NUMBER |
(15) |
|
|
VENDOR_ID |
NUMBER |
(15) |
|
|
ACTIVE |
VARCHAR2 |
(30) |
|
|
PERSON_TYPE |
VARCHAR2 |
(30) |
|
- Person_type |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, FULL_NAME
, EMPLOYEE_NUMBER
, LAST_NAME
, FIRST_NAME
, MIDDLE_NAMES
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, EXPENSE_CHECK_SEND_TO_ADDRESS
, BUSINESS_GROUP_ID
, VENDOR_ID
, ACTIVE
, PERSON_TYPE
FROM APPS.PA_EMPLOYEES;
Dependencies
[top of page]
APPS.PA_EMPLOYEES references the following:
-
APPS
-
HR_GENERAL
- show dependent code
-
HR_PERSON_NAME
- show dependent code
-
HR_SECURITY
- show dependent code
-
PER_ALL_PEOPLE_F
-
PER_PEOPLE_F
-
PER_PERSON_TYPES
-
PER_PERSON_TYPE_USAGES_F
APPS.PA_EMPLOYEES is referenced by following:
-
APPS
-
GMS_AWARD_PVT
- show dependent code
-
GMS_EMPLOYEES
-
GMS_ENC_ADJUSTMENTS
- show dependent code
-
PA_AGREEMENT_CORE
- show dependent code
-
PA_BILLING_SETUP_UTILS
- show dependent code
-
PA_BILL_WORKBENCH_INVOICE
- show dependent code
-
PA_BUDGET_ACCOUNT_PKG
- show dependent code
-
PA_BUDGET_ACCOUNT_PKG
- show dependent code
-
PA_BUDGET_WF
- show dependent code
-
PA_CC_BL_CUR_SEL_V
-
PA_COST_DIST_OVERRIDES_V
-
PA_EMPLOYEES_RES_V
-
PA_EXPENDITURE_HISTORY_V
-
PA_HR_UPDATE_PA_ENTITIES
- show dependent code
-
PA_HR_UPDATE_PA_ENTITIES
- show dependent code
-
PA_KEY_MEMBERS_LOV_V
-
PA_OVERRIDE_FIELD_VALUES_V
-
PA_OWNED_BY_LOV_V
-
PA_PROGRESS_REPORT_PVT
- show dependent code
-
PA_PROJECT_PARTIES_UTILS
- show dependent code
-
PA_PROJECT_PVT
- show dependent code
-
PA_PROJECT_WF
- show dependent code
-
PA_PROJ_PARTIES_PROG_EDIT_V
-
PA_PROJ_PARTIES_PROG_EV_V
-
PA_PWP_NOTIFICATION
- show dependent code
-
PA_QUERY_RES_LIST_MEMBERS_V
-
PA_RESOURCE_UTILS
- show dependent code
-
PA_RESOURCE_UTILS
- show dependent code
-
PA_TASKS_MAINT_UTILS
- show dependent code
-
PA_TASK_MANAGERS_LOV_V
-
PA_TXN_ACCUM_V
-
PA_UTILS
- show dependent code
-
PA_XLA_EMPLOYEE_REF_V