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

VIEW: APPS.PAY_KR_EMP_DETAILS_V

Object Details
Object Name: PAY_KR_EMP_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_KR_EMP_DETAILS_V
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
EMP_ESTABLISHMENT_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS
EMP_ASSIGNMENT_ID NUMBER (10) Yes System-generated primary key column.
EMP_PERSON_ID NUMBER (10) Yes System generated person primary key from PER_PEOPLE_S.
EMP_FULL_NAME VARCHAR2 (300)
Concatenation of last name, title, first name, middle names and the name the person is known by.
EMP_NI_NUMBER VARCHAR2 (30)
Number by which a person is identified in a given legislation.
EMP_DATE_OF_BIRTH DATE

EMP_SEX VARCHAR2 (30)
EMP_START_DATE DATE
Yes
EMP_END_DATE DATE
Yes
PERSON_START_DATE DATE
Yes
PERSON_END_DATE DATE
Yes
COMPANY_REG_NUM VARCHAR2 (150)
COMPANY_NAME VARCHAR2 (150)
COUNTRY_OF_BIRTH VARCHAR2 (90)
NATIONALITY_CODE VARCHAR2 (30)
Query Text

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


SELECT EMP_ESTABLISHMENT_ID
,      EMP_ASSIGNMENT_ID
,      EMP_PERSON_ID
,      EMP_FULL_NAME
,      EMP_NI_NUMBER
,      EMP_DATE_OF_BIRTH
,      EMP_SEX
,      EMP_START_DATE
,      EMP_END_DATE
,      PERSON_START_DATE
,      PERSON_END_DATE
,      COMPANY_REG_NUM
,      COMPANY_NAME
,      COUNTRY_OF_BIRTH
,      NATIONALITY_CODE
FROM APPS.PAY_KR_EMP_DETAILS_V;

Dependencies

[top of page]

APPS.PAY_KR_EMP_DETAILS_V references the following:

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

APPS.PAY_KR_EMP_DETAILS_V is not referenced by any database object