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

VIEW: APPS.PAYBV_ELEMENT_LINK

Object Details
Object Name: PAYBV_ELEMENT_LINK
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAYBV_ELEMENT_LINK
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
COSTABLE_TYPE VARCHAR2 (4000)
LINK_TO_ALL_PAYROLLS_FLAG VARCHAR2 (4000)
MULTIPLY_VALUE_FLAG VARCHAR2 (4000)
STANDARD_LINK_FLAG VARCHAR2 (4000)
TRANSFER_TO_GL_FLAG VARCHAR2 (4000)
EMPLOYMENT_CATEGORY VARCHAR2 (4000)
QUALIFYING_AGE NUMBER (2)
QUALIFYING_LENGTH_OF_SERVICE NUMBER (6)
QUALIFYING_UNITS VARCHAR2 (4000)
_DF:AEL CHAR (29)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
COSTABLE_TYPE_CODE VARCHAR2 (30) Yes
LINK_TO_ALL_PAYROLLS_FLAG_CODE VARCHAR2 (30) Yes
MULTIPLY_VALUE_FLAG_CODE VARCHAR2 (30) Yes
STANDARD_LINK_FLAG_CODE VARCHAR2 (30) Yes
TRANSFER_TO_GL_FLAG_CODE VARCHAR2 (30) Yes
EMPLOYMENT_CATEGORY_CODE VARCHAR2 (30)
QUALIFYING_UNITS_CODE VARCHAR2 (30)
ELEMENT_LINK_ID NUMBER (9) Yes
PAYROLL_ID NUMBER (9)
JOB_ID NUMBER (15)
POSITION_ID NUMBER (15)
PEOPLE_GROUP_ID NUMBER (15)
COST_ALLOCATION_KEYFLEX_ID NUMBER (9)
ORGANIZATION_ID NUMBER (15)
ELEMENT_TYPE_ID NUMBER (9) Yes
LOCATION_ID NUMBER (15)
GRADE_ID NUMBER (15)
BALANCING_KEYFLEX_ID NUMBER (9)
BUSINESS_GROUP_ID NUMBER (15) Yes
ELEMENT_SET_ID NUMBER (9)
PAY_BASIS_ID NUMBER (9)
COMMENT_ID NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9)
BG_SECURITY_FLAG_CODE CHAR (1)
Query Text

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


SELECT EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      COSTABLE_TYPE
,      LINK_TO_ALL_PAYROLLS_FLAG
,      MULTIPLY_VALUE_FLAG
,      STANDARD_LINK_FLAG
,      TRANSFER_TO_GL_FLAG
,      EMPLOYMENT_CATEGORY
,      QUALIFYING_AGE
,      QUALIFYING_LENGTH_OF_SERVICE
,      QUALIFYING_UNITS
,      _DF:AEL
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      COSTABLE_TYPE_CODE
,      LINK_TO_ALL_PAYROLLS_FLAG_CODE
,      MULTIPLY_VALUE_FLAG_CODE
,      STANDARD_LINK_FLAG_CODE
,      TRANSFER_TO_GL_FLAG_CODE
,      EMPLOYMENT_CATEGORY_CODE
,      QUALIFYING_UNITS_CODE
,      ELEMENT_LINK_ID
,      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
,      COMMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      BG_SECURITY_FLAG_CODE
FROM APPS.PAYBV_ELEMENT_LINK;

Dependencies

[top of page]

APPS.PAYBV_ELEMENT_LINK references the following:

SchemaAPPS
PL/SQL PackageHR_BIS - show dependent code
SynonymPAY_ELEMENT_LINKS_F

APPS.PAYBV_ELEMENT_LINK is not referenced by any database object