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

VIEW: APPS.PAY_ELEMENT_LINK_API_V

Object Details
Object Name: PAY_ELEMENT_LINK_API_V
Object Type: VIEW
Owner: APPS
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
Name Datatype Length Mandatory Comments
ELEMENT_LINK_ID NUMBER (9) Yes System-generated primary key column.
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.
JOB_ID NUMBER (15)
Foreign key to PER_JOBS.
POSITION_ID NUMBER (15)
Foreign key to PER_POSITIONS.
PEOPLE_GROUP_ID NUMBER (15)
Foreign key to PAY_PEOPLE_GROUPS.
COST_ALLOCATION_KEYFLEX_ID NUMBER (9)
Foreign key to PAY_COST_ALLOCATION_KEYFLEX.
ORGANIZATION_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS.
ELEMENT_TYPE_ID NUMBER (9) Yes Foreign key to PAY_ELEMENT_TYPES_F.
LOCATION_ID NUMBER (15)
Foreign key to HR_LOCATIONS.
GRADE_ID NUMBER (15)
Foreign key to PER_GRADES.
BALANCING_KEYFLEX_ID NUMBER (9)
Foreign key to PAY_COST_ALLOCATION_KEYFLEX.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
ELEMENT_SET_ID NUMBER (9)
Foreign key to PAY_ELEMENT_SETS.
PAY_BASIS_ID NUMBER (9)
Foreign key to PER_PAY_BASES.
COSTABLE_TYPE VARCHAR2 (30) Yes Costable type for element entries subject to this link. (Validated by a lookup).
LINK_TO_ALL_PAYROLLS_FLAG VARCHAR2 (30) Yes Indicates whether all payrolls are eligible for the element.
MULTIPLY_VALUE_FLAG VARCHAR2 (30) Yes Indicates whether entries can be multiplied, for example, holiday pay.
STANDARD_LINK_FLAG VARCHAR2 (30) Yes Indicates whether an element is standard (Y) or non-standard (N).
TRANSFER_TO_GL_FLAG VARCHAR2 (30) Yes Indicates whether costed values for the element can be included in the transfer to General Ledger.
COMMENT_ID NUMBER (15)
Foreign key to HR_COMMENTS.
EMPLOYMENT_CATEGORY VARCHAR2 (30)
Employment category criteria for the element. Validated by lookup.
QUALIFYING_AGE NUMBER (2)
Minimum age criteria for the element.
QUALIFYING_LENGTH_OF_SERVICE NUMBER (6)
Minimum length of service for eligibility for the element.
QUALIFYING_UNITS VARCHAR2 (30)
Time units used by the QUALIFYING_LENGTH_OF_SERVICE. (Validated by a lookup).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
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.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update.
COST_CONCATENATED_SEGMENTS VARCHAR2 (2000)
Key flexfield segment column.
COST_ID_FLEX_NUM NUMBER (15)
Key flexfield structure foreign key.
COST_SUMMARY_FLAG VARCHAR2 (1)
Key flexfield summary flag.
COST_ENABLED_FLAG VARCHAR2 (1)
Key flexfield enabled flag.
COST_START_DATE_ACTIVE DATE

Date before which key flexfield combination is invalid.
COST_END_DATE_ACTIVE DATE

Date after which key flexfield combination is invalid.
COST_SEGMENT1 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT2 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT3 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT4 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT5 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT6 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT7 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT8 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT9 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT10 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT11 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT12 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT13 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT14 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT15 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT16 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT17 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT18 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT19 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT20 VARCHAR2 (60)
Key flexfield segment
COST_SEGMENT21 VARCHAR2 (60)
Key flexfield segment column.
COST_SEGMENT22 VARCHAR2 (60)
Key flexfield segment column.
COST_SEGMENT23 VARCHAR2 (60)
Key flexfield segment column.
COST_SEGMENT24 VARCHAR2 (60)
Key flexfield segment column.
COST_SEGMENT25 VARCHAR2 (60)
Key flexfield segment column.
COST_SEGMENT26 VARCHAR2 (60)
Key flexfield segment column.
COST_SEGMENT27 VARCHAR2 (60)
Key flexfield segment column.
COST_SEGMENT28 VARCHAR2 (60)
Key flexfield segment column.
COST_SEGMENT29 VARCHAR2 (60)
Key flexfield segment column.
COST_SEGMENT30 VARCHAR2 (60)
Key flexfield segment column.
BALANCE_CONCATENATED_SEGMENTS VARCHAR2 (2000)
Key flexfield segment column.
BALANCE_ID_FLEX_NUM NUMBER (15)
Key flexfield structure foreign key.
BALANCE_SUMMARY_FLAG VARCHAR2 (1)
Key flexfield summary flag.
BALANCE_ENABLED_FLAG VARCHAR2 (1)
Key flexfield enabled flag.
BALANCE_START_DATE_ACTIVE DATE

Date before which key flexfield combination is invalid.
BALANCE_END_DATE_ACTIVE DATE

Date after which key flexfield combination is invalid.
BALANCE_SEGMENT1 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT2 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT3 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT4 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT5 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT6 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT7 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT8 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT9 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT10 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT11 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT12 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT13 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT14 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT15 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT16 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT17 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT18 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT19 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT20 VARCHAR2 (60)
Key flexfield segment
BALANCE_SEGMENT21 VARCHAR2 (60)
Key flexfield segment column.
BALANCE_SEGMENT22 VARCHAR2 (60)
Key flexfield segment column.
BALANCE_SEGMENT23 VARCHAR2 (60)
Key flexfield segment column.
BALANCE_SEGMENT24 VARCHAR2 (60)
Key flexfield segment column.
BALANCE_SEGMENT25 VARCHAR2 (60)
Key flexfield segment column.
BALANCE_SEGMENT26 VARCHAR2 (60)
Key flexfield segment column.
BALANCE_SEGMENT27 VARCHAR2 (60)
Key flexfield segment column.
BALANCE_SEGMENT28 VARCHAR2 (60)
Key flexfield segment column.
BALANCE_SEGMENT29 VARCHAR2 (60)
Key flexfield segment column.
BALANCE_SEGMENT30 VARCHAR2 (60)
Key flexfield segment column.
BALANCE_LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
BALANCE_LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
BALANCE_LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
BALANCE_CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
BALANCE_CREATION_DATE DATE

Standard who column - date when this row was created.
Query Text

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


SELECT ELEMENT_LINK_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PAYROLL_ID
,      JOB_ID
,      POSITION_ID
,      PEOPLE_GROUP_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      ORGANIZATION_ID
,      ELEMENT_TYPE_ID
,      LOCATION_ID
,      GRADE_ID
,      BALANCING_KEYFLEX_ID
,      BUSINESS_GROUP_ID
,      ELEMENT_SET_ID
,      PAY_BASIS_ID
,      COSTABLE_TYPE
,      LINK_TO_ALL_PAYROLLS_FLAG
,      MULTIPLY_VALUE_FLAG
,      STANDARD_LINK_FLAG
,      TRANSFER_TO_GL_FLAG
,      COMMENT_ID
,      EMPLOYMENT_CATEGORY
,      QUALIFYING_AGE
,      QUALIFYING_LENGTH_OF_SERVICE
,      QUALIFYING_UNITS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      COST_CONCATENATED_SEGMENTS
,      COST_ID_FLEX_NUM
,      COST_SUMMARY_FLAG
,      COST_ENABLED_FLAG
,      COST_START_DATE_ACTIVE
,      COST_END_DATE_ACTIVE
,      COST_SEGMENT1
,      COST_SEGMENT2
,      COST_SEGMENT3
,      COST_SEGMENT4
,      COST_SEGMENT5
,      COST_SEGMENT6
,      COST_SEGMENT7
,      COST_SEGMENT8
,      COST_SEGMENT9
,      COST_SEGMENT10
,      COST_SEGMENT11
,      COST_SEGMENT12
,      COST_SEGMENT13
,      COST_SEGMENT14
,      COST_SEGMENT15
,      COST_SEGMENT16
,      COST_SEGMENT17
,      COST_SEGMENT18
,      COST_SEGMENT19
,      COST_SEGMENT20
,      COST_SEGMENT21
,      COST_SEGMENT22
,      COST_SEGMENT23
,      COST_SEGMENT24
,      COST_SEGMENT25
,      COST_SEGMENT26
,      COST_SEGMENT27
,      COST_SEGMENT28
,      COST_SEGMENT29
,      COST_SEGMENT30
,      BALANCE_CONCATENATED_SEGMENTS
,      BALANCE_ID_FLEX_NUM
,      BALANCE_SUMMARY_FLAG
,      BALANCE_ENABLED_FLAG
,      BALANCE_START_DATE_ACTIVE
,      BALANCE_END_DATE_ACTIVE
,      BALANCE_SEGMENT1
,      BALANCE_SEGMENT2
,      BALANCE_SEGMENT3
,      BALANCE_SEGMENT4
,      BALANCE_SEGMENT5
,      BALANCE_SEGMENT6
,      BALANCE_SEGMENT7
,      BALANCE_SEGMENT8
,      BALANCE_SEGMENT9
,      BALANCE_SEGMENT10
,      BALANCE_SEGMENT11
,      BALANCE_SEGMENT12
,      BALANCE_SEGMENT13
,      BALANCE_SEGMENT14
,      BALANCE_SEGMENT15
,      BALANCE_SEGMENT16
,      BALANCE_SEGMENT17
,      BALANCE_SEGMENT18
,      BALANCE_SEGMENT19
,      BALANCE_SEGMENT20
,      BALANCE_SEGMENT21
,      BALANCE_SEGMENT22
,      BALANCE_SEGMENT23
,      BALANCE_SEGMENT24
,      BALANCE_SEGMENT25
,      BALANCE_SEGMENT26
,      BALANCE_SEGMENT27
,      BALANCE_SEGMENT28
,      BALANCE_SEGMENT29
,      BALANCE_SEGMENT30
,      BALANCE_LAST_UPDATE_DATE
,      BALANCE_LAST_UPDATED_BY
,      BALANCE_LAST_UPDATE_LOGIN
,      BALANCE_CREATED_BY
,      BALANCE_CREATION_DATE
FROM APPS.PAY_ELEMENT_LINK_API_V;

Dependencies

[top of page]

APPS.PAY_ELEMENT_LINK_API_V references the following:

SchemaAPPS
SynonymPAY_COST_ALLOCATION_KEYFLEX
SynonymPAY_ELEMENT_LINKS_F
APPS.PAY_ELEMENT_LINK_API_V is referenced by following:

SchemaPUBLIC
SynonymPAY_ELEMENT_LINK_API_V