[Home] [Help] [Dependency Information]

VIEW: APPS.HRFV_GRD_STEP_PLACEMNT_HISTORY

Object Details

Object Name:	HRFV_GRD_STEP_PLACEMNT_HISTORY
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HRFV_GRD_STEP_PLACEMNT_HISTORY
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view shows the history of changes to grade steps for current employees.
The start and end dates show the dates employees have
changed grade step.

[View Source]

Columns

Query Text

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

SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      EMPLOYEE_NUMBER
,      ASSIGNMENT_NUMBER
,      PAY_SCALE_NAME
,      GRADE_NAME
,      GRADE_STEP
,      GRADE_POINT
,      PLACEMENT_REASON
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      GRADE_ID
,      PAY_SCALE_ID
,      PERSON_ID
,      STEP_ID
FROM APPS.HRFV_GRD_STEP_PLACEMNT_HISTORY;

Dependencies

[top of page]

APPS

HR_ALL_ORGANIZATION_UNITS_TL

HR_BIS - show dependent code

HR_DISCOVERER - show dependent code

HR_GENERAL - show dependent code

HR_PERSON_NAME - show dependent code

HR_SECURITY - show dependent code

PER_ASSIGNMENTS_F

PER_GRADES_TL

PER_PARENT_SPINES

PER_PEOPLE_X

PER_SPINAL_POINTS

PER_SPINAL_POINT_PLACEMENTS_F

PER_SPINAL_POINT_STEPS_F

PUBLIC

HRFV_GRD_STEP_PLACEMNT_HISTORY