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

VIEW: APPS.PER_EMPLOYEES_CURRENT_X

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

View Type

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


The list of current employees visible within the current security
profile as of the current system date.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_ID NUMBER (15) Yes Business Group Id.
ORGANIZATION_ID NUMBER (15) Yes Organization Id.
EMPLOYEE_ID NUMBER (10) Yes Employee Id.
ASSIGNMENT_ID NUMBER (10) Yes Assignment Id.
LAST_UPDATE_DATE DATE

Standard who column.
LAST_UPDATED_BY NUMBER (15)
Standard who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column.
CREATION_DATE DATE

Standard who column.
CREATED_BY NUMBER (15)
Standard who column.
EMPLOYEE_NUM VARCHAR2 (30)
Employee number.
FULL_NAME VARCHAR2 (240)
Full Name.
FIRST_NAME VARCHAR2 (150)
First Name.
MIDDLE_NAME VARCHAR2 (60)
Middle Name.
LAST_NAME VARCHAR2 (150) Yes Last Name
PREFIX VARCHAR2 (30)
Prefix.
LOCATION_ID NUMBER (15)
Working Location Id.
SUPERVISOR_ID NUMBER (10)
Supervisor Id.
SET_OF_BOOKS_ID NUMBER (15)
Set of Books Id.
DEFAULT_CODE_COMBINATION_ID NUMBER (15)
Identifies GL key flexfield structure.
EXPENSE_CHECK_ADDRESS_FLAG VARCHAR2 (30)
Mailing address.
INACTIVE_DATE DATE

Inactive date.
EMAIL_ADDRESS VARCHAR2 (240)
Email Address.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE21 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE22 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE23 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE24 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE25 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE26 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE27 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE28 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE29 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE30 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield column.
PARTY_ID NUMBER (15)
foreign key to HZ_PARTIES
GLOBAL_NAME VARCHAR2 (240)
Stores personal name according to the defined Global List Name format
LOCAL_NAME VARCHAR2 (240)
Stores personal name according to the defined Local List Name format
LIST_NAME VARCHAR2 (4000)
Either a global or local name depending on the profile option
Query Text

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


SELECT BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      EMPLOYEE_ID
,      ASSIGNMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      EMPLOYEE_NUM
,      FULL_NAME
,      FIRST_NAME
,      MIDDLE_NAME
,      LAST_NAME
,      PREFIX
,      LOCATION_ID
,      SUPERVISOR_ID
,      SET_OF_BOOKS_ID
,      DEFAULT_CODE_COMBINATION_ID
,      EXPENSE_CHECK_ADDRESS_FLAG
,      INACTIVE_DATE
,      EMAIL_ADDRESS
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      PARTY_ID
,      GLOBAL_NAME
,      LOCAL_NAME
,      LIST_NAME
FROM APPS.PER_EMPLOYEES_CURRENT_X;

Dependencies

[top of page]

APPS.PER_EMPLOYEES_CURRENT_X 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
SynonymPER_ALL_ASSIGNMENTS_F
ViewPER_PEOPLE_F
SynonymPER_PERIODS_OF_SERVICE
APPS.PER_EMPLOYEES_CURRENT_X is referenced by following:

SchemaAPPS
Package BodyAP_IAW_PKG - show dependent code
Package BodyAP_WEB_CUST_AME_PKG - show dependent code
Package BodyAP_WEB_DB_HR_INT_PKG - show dependent code
PL/SQL PackageAP_WEB_DB_HR_INT_PKG - show dependent code
PL/SQL PackageAP_WEB_INACTIVE_EMP_WF_PKG - show dependent code
ViewAP_WEB_SIGNING_LIMITS_V
Package BodyAP_WEB_UPLOAD_ACCUM_MILES_PKG - show dependent code
Package BodyAP_WFAPPROVAL_PKG - show dependent code
Package BodyAP_WORKFLOW_PKG - show dependent code
Package BodyASO_PA_APR_WF_PVT - show dependent code
ViewCSD_INCIDENTS_NON_SEC_V
ViewCSD_INCIDENTS_V
Package BodyCSD_RECEIVE_UTIL - show dependent code
Package BodyCSI_MASS_EDIT_PUB - show dependent code
Package BodyCSP_RECEIVE_PVT - show dependent code
Package BodyIEX_UWQ_VIEW_PKG - show dependent code
Package BodyIGIDOSL - show dependent code
Package BodyIGI_EXP_APPROVAL_PKG - show dependent code
PL/SQL PackageJTF_RS_RESOURCE_PUB - show dependent code
Package BodyJTF_RS_RESOURCE_PUB - show dependent code
Package BodyOKE_POOL_PVT - show dependent code
Package BodyPNP_UTIL_FUNC - show dependent code
Package BodyPOR_AME_RCO_WF_PVT - show dependent code
Package BodyPOR_AME_REQ_WF_PVT - show dependent code
ViewPOR_APPROVER_LOV_V
ViewPOR_BUYER_LOV_V
Package BodyPOR_UTIL_PKG - show dependent code
Package BodyPOS_SUPP_APPR - show dependent code
Package BodyPOS_WCAPPROVE_PVT - show dependent code
Package BodyPOS_WC_CREATE_UPDATE_PVT - show dependent code
Package BodyPO_AME_WF_PVT - show dependent code
Package BodyPO_AUTO_HEADER_PROCESS_PVT - show dependent code
Package BodyPO_DOCUMENT_ACTION_CHECK - show dependent code
Package BodyPO_DOCUMENT_ACTION_UTIL - show dependent code
Package BodyPO_EMPLOYEES_SV - show dependent code
ViewPO_LINES_REF_V
Package BodyPO_R12_CAT_UPG_DEF_PVT - show dependent code
ViewPO_REQ_LINES_REF_V