[Home] [Help]
[Dependency Information]
| Object Name: | HR_H2PI_ELEMENT_ENTRY_VALUES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PER.HR_H2PI_ELEMENT_ENTRY_VALUES_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LAST_UPD_DATE | DATE | Last update date | ||
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ORGANIZATION_UNITS. |
| ELEMENT_ENTRY_ID | NUMBER | (15) | Yes | System-generated primary key column. |
| PERSON_ID | NUMBER | (10) | Yes | Foreign key to PER_PEOPLE. |
| EFFECTIVE_START_DATE | DATE | Yes | Effective start date. | |
| EFFECTIVE_END_DATE | DATE | Yes | Effective end date. | |
| INPUT_VALUE_ID | NUMBER | (9) | Yes | Foreign key to PAY_INPUT_VALUES. |
| SCREEN_ENTRY_VALUE | VARCHAR2 | (60) | Actual entry value. |
Cut, paste (and edit) the following text to query this object:
SELECT LAST_UPD_DATE
, BUSINESS_GROUP_ID
, ELEMENT_ENTRY_ID
, PERSON_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, INPUT_VALUE_ID
, SCREEN_ENTRY_VALUE
FROM APPS.HR_H2PI_ELEMENT_ENTRY_VALUES_V;
APPS
HR_H2PI_ELEMENT_ENTRIES_V
PAY_ELEMENT_ENTRY_VALUES_F
APPS
HR_H2PI_PERSON_UPLOAD
- show dependent code
HR_H2PI_VALIDATE
- show dependent code
|
|
|
|