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

VIEW: APPS.HR_H2PI_ELEMENT_LINKS_V

Object Details
Object Name: HR_H2PI_ELEMENT_LINKS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_H2PI_ELEMENT_LINKS_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 Source]

Columns
Name Datatype Length Mandatory Comments
LAST_UPD_DATE DATE

Last update date.
ELEMENT_LINK_ID NUMBER (9) Yes System-generated primary key column.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
PAYROLL_ID NUMBER (9)
Foreign key to PAY_ALL_PAYROLLS_F.
COST_ALLOCATION_KEYFLEX_ID NUMBER (9)
Foreign key to PAY_COST_ALLOCATION_KEYFLEX.
ELEMENT_TYPE_ID NUMBER (9) Yes Foreign key to PAY_ELEMENT_TYPES_F.
ORGANIZATION_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS.
LOCATION_ID NUMBER (15)
Foreign key to HR_LOCATIONS.
PAY_BASIS_ID NUMBER (9)
Foreign key to PER_PAY_BASES.
LINK_TO_ALL_PAYROLLS_FLAG VARCHAR2 (30) Yes Indicates whether all payrolls are eligible for the element.
Query Text

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


SELECT LAST_UPD_DATE
,      ELEMENT_LINK_ID
,      BUSINESS_GROUP_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PAYROLL_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      ELEMENT_TYPE_ID
,      ORGANIZATION_ID
,      LOCATION_ID
,      PAY_BASIS_ID
,      LINK_TO_ALL_PAYROLLS_FLAG
FROM APPS.HR_H2PI_ELEMENT_LINKS_V;

Dependencies

[top of page]

APPS.HR_H2PI_ELEMENT_LINKS_V references the following:

SchemaAPPS
ViewHR_H2PI_ELEMENT_TYPES_V
SynonymPAY_ELEMENT_LINKS_F
APPS.HR_H2PI_ELEMENT_LINKS_V is referenced by following:

SchemaAPPS
Package BodyHR_H2PI_VALIDATE - show dependent code