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

VIEW: APPS.PER_GRADES_VL

Object Details
Object Name: PER_GRADES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_GRADES_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


Single language join of PER_GRADES and PER_GRADES_TL


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Internal row identifier.
GRADE_ID NUMBER (15) Yes System-generated primary key column.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
GRADE_DEFINITION_ID NUMBER (15) Yes System-generated primary key column.
DATE_FROM DATE
Yes The date on which the grade becomes effective.
SEQUENCE NUMBER (15) Yes Sequence number for the grade. Used for ordering a list of grades.
COMMENTS LONG (0)
General remark.
DATE_TO DATE

The date after which the grade is no longer effective.
NAME VARCHAR2 (240)
Grade name.
REQUEST_ID NUMBER (15)
Standard Who Column.
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column.
PROGRAM_ID NUMBER (15)
Standard Who Column.
PROGRAM_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
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.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
INFORMATION_CATEGORY VARCHAR2 (30)
Developer descriptive flexfield column.
INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update.
SHORT_NAME VARCHAR2 (30)
Short name
Query Text

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


SELECT ROW_ID
,      GRADE_ID
,      BUSINESS_GROUP_ID
,      GRADE_DEFINITION_ID
,      DATE_FROM
,      SEQUENCE
,      COMMENTS
,      DATE_TO
,      NAME
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      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
,      INFORMATION_CATEGORY
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      OBJECT_VERSION_NUMBER
,      SHORT_NAME
FROM APPS.PER_GRADES_VL;

Dependencies

[top of page]

APPS.PER_GRADES_VL references the following:

SchemaAPPS
SynonymPER_GRADES
SynonymPER_GRADES_TL
APPS.PER_GRADES_VL is referenced by following:

SchemaAPPS
ViewBEN_ASSIGNMENT_D
ViewBEN_ELIG_GRD_PRTE_D
Package BodyBEN_EXT_PERSON - show dependent code
Package BodyBEN_EXT_THREAD - show dependent code
ViewBEN_GRADE_RT_D
Package BodyBEN_PD_RATE_AND_CVG_MODULE - show dependent code
Package BodyBEN_PLAN_DESIGN_ELPRO_MODULE - show dependent code
Package BodyBEN_PLAN_DESIGN_PROGRAM_MODULE - show dependent code
Package BodyBEN_PLAN_DESIGN_TXNS_API - show dependent code
Package BodyHR_GENERAL - show dependent code
Package BodyHR_MEE_VIEWS_GEN - show dependent code
Package BodyHR_PROCESS_ASSIGNMENT_SS - show dependent code
Package BodyHR_PUMP_GET - show dependent code
Package BodyHR_REPORTS - show dependent code
Package BodyHR_SPP_EXCEPTION_DATA - show dependent code
Package BodyHR_SPP_WI_DATA - show dependent code
Package BodyHXC_RESOURCE_RULES_UTILS - show dependent code
Package BodyPAY_DB_PAY_SETUP - show dependent code
Package BodyPAY_EMP_ACTION_ARCH - show dependent code
Package BodyPAY_FR_DB_PAY_SETUP - show dependent code
Package BodyPAY_PAYFV_ELEMENT_ENTRIES_PKG - show dependent code
Package BodyPER_APPLICANT_PKG - show dependent code
Package BodyPER_DB_PER_ADDITIONAL - show dependent code
Package BodyPER_GRADES_PKG - show dependent code
Package BodyPER_PAY_PROPOSALS_POPULATE - show dependent code
Package BodyPER_PERRPREQ_XMLP_PKG - show dependent code
Package BodyPER_QH_FIND_QUERY - show dependent code
Package BodyPER_QH_POPULATE - show dependent code
Package BodyPER_SALADMIN_UTILITY - show dependent code
Package BodyPER_SPINAL_PT_PLCMT_PKG - show dependent code
Package BodyPQH_COMMITMENT_PKG - show dependent code
Package BodyPQH_CORPS_COPY - show dependent code
Package BodyPQH_LENGTH_OF_SERVICE_PKG - show dependent code
Package BodyPQH_RSS_BUS - show dependent code
SchemaPUBLIC
SynonymPER_GRADES_VL