[Home] [Help] [Dependency Information]

VIEW: APPS.PER_PEOPLE

Object Details

Object Name:	PER_PEOPLE
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.PER_PEOPLE
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT PERSON_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      PERSON_TYPE_ID
,      LAST_NAME
,      START_DATE
,      APPLICANT_NUMBER
,      COMMENT_ID
,      CURRENT_APPLICANT_FLAG
,      CURRENT_EMP_OR_APL_FLAG
,      CURRENT_EMPLOYEE_FLAG
,      DATE_EMPLOYEE_DATA_VERIFIED
,      DATE_OF_BIRTH
,      EMAIL_ADDRESS
,      EMPLOYEE_NUMBER
,      EXPENSE_CHECK_SEND_TO_ADDRESS
,      FIRST_NAME
,      FULL_NAME
,      ORDER_NAME
,      KNOWN_AS
,      MARITAL_STATUS
,      MIDDLE_NAMES
,      NATIONALITY
,      NATIONAL_IDENTIFIER
,      PREVIOUS_LAST_NAME
,      REGISTERED_DISABLED_FLAG
,      SEX
,      TITLE
,      VENDOR_ID
,      WORK_TELEPHONE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      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
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PER_INFORMATION_CATEGORY
,      PER_INFORMATION1
,      PER_INFORMATION2
,      PER_INFORMATION3
,      PER_INFORMATION4
,      PER_INFORMATION5
,      PER_INFORMATION6
,      PER_INFORMATION7
,      PER_INFORMATION8
,      PER_INFORMATION9
,      PER_INFORMATION10
,      PER_INFORMATION11
,      PER_INFORMATION12
,      PER_INFORMATION13
,      PER_INFORMATION14
,      PER_INFORMATION15
,      PER_INFORMATION16
,      PER_INFORMATION17
,      PER_INFORMATION18
,      PER_INFORMATION19
,      PER_INFORMATION20
,      PER_INFORMATION21
,      PER_INFORMATION22
,      PER_INFORMATION23
,      PER_INFORMATION24
,      PER_INFORMATION25
,      PER_INFORMATION26
,      PER_INFORMATION27
,      PER_INFORMATION28
,      PER_INFORMATION29
,      PER_INFORMATION30
,      OBJECT_VERSION_NUMBER
,      SUFFIX
,      WORK_SCHEDULE
,      CORRESPONDENCE_LANGUAGE
,      STUDENT_STATUS
,      FTE_CAPACITY
,      ON_MILITARY_SERVICE
,      SECOND_PASSPORT_EXISTS
,      BACKGROUND_CHECK_STATUS
,      BACKGROUND_DATE_CHECK
,      BLOOD_TYPE
,      LAST_MEDICAL_TEST_DATE
,      LAST_MEDICAL_TEST_BY
,      REHIRE_RECOMMENDATION
,      REHIRE_AUTHORIZOR
,      REHIRE_REASON
,      RESUME_EXISTS
,      RESUME_LAST_UPDATED
,      OFFICE_NUMBER
,      INTERNAL_LOCATION
,      MAILSTOP
,      PROJECTED_START_DATE
,      HONORS
,      PRE_NAME_ADJUNCT
,      HOLD_APPLICANT_DATE_UNTIL
,      COORD_BEN_MED_PLN_NO
,      COORD_BEN_NO_CVG_FLAG
,      DPDNT_ADOPTION_DATE
,      DPDNT_VLNTRY_SVCE_FLAG
,      RECEIPT_OF_DEATH_CERT_DATE
,      USES_TOBACCO_FLAG
,      BENEFIT_GROUP_ID
,      DATE_OF_DEATH
,      ORIGINAL_DATE_OF_HIRE
,      TOWN_OF_BIRTH
,      REGION_OF_BIRTH
,      COUNTRY_OF_BIRTH
,      GLOBAL_PERSON_ID
,      COORD_BEN_MED_EXT_ER
,      COORD_BEN_MED_PL_NAME
,      COORD_BEN_MED_INSR_CRR_NAME
,      COORD_BEN_MED_INSR_CRR_IDENT
,      COORD_BEN_MED_CVG_STRT_DT
,      COORD_BEN_MED_CVG_END_DT
,      USER_PERSON_TYPE
,      NPW_NUMBER
,      CURRENT_NPW_FLAG
,      GLOBAL_NAME
,      LOCAL_NAME
,      LIST_NAME
FROM APPS.PER_PEOPLE;

Dependencies

[top of page]

APPS

FND_SESSIONS

HR_GENERAL - show dependent code

HR_PERSON_NAME - show dependent code

HR_PERSON_TYPE_USAGE_INFO - show dependent code

HR_SECURITY - show dependent code

PER_PEOPLE_F

APPS

BEN_PEOPLE_RSLT_V

HR_OFFER_CUSTOM - show dependent code

HXC_TIMEKEEPER_GROUP_API - show dependent code

HXC_TK_GROUPS_V

HXC_TK_GROUP_QUERY_CRITERIA_V

HXC_TK_GRP_QUERY_CRITERIA_API - show dependent code

HXT_EMP_TIME_INFO_V

PAAPIMP_PKG - show dependent code

PAY_CA_DIRECT_DEPOSIT_PKG - show dependent code

PAY_P45_V1

PER_EXPANDED_ANALYSES_VIEW

PER_EXPANDED_ANALYSES_VIEW2

PER_LETTER_REQUEST_LINES_V

PER_QP_INVOCATIONS - show dependent code

PER_QUICKPAINT_ASSIGNMENTS