View: PER_GRADE_SPINES_D

Product:	PER - Human Resources
Description:	Used by Datetrack History
Implementation/DBA Data:	APPS.PER_GRADE_SPINES_D

View Text

SELECT GSPINE.GRADE_SPINE_ID
, GSPINE.EFFECTIVE_START_DATE
, GSPINE.EFFECTIVE_END_DATE
, PARENT.NAME
, GDT.NAME
, POINT.SPINAL_POINT
, GSPINE.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM PER_GRADE_SPINES_F GSPINE
, PER_PARENT_SPINES PARENT
, PER_GRADES_TL GDT
, PER_SPINAL_POINTS POINT
, PER_SPINAL_POINT_STEPS_F STEP
, FND_USER FUSER
WHERE PARENT.PARENT_SPINE_ID = GSPINE.PARENT_SPINE_ID
AND GDT.GRADE_ID = GSPINE.GRADE_ID
AND GDT.LANGUAGE = USERENV('LANG')
AND STEP.STEP_ID = GSPINE.CEILING_STEP_ID
AND GSPINE.EFFECTIVE_START_DATE BETWEEN STEP.EFFECTIVE_START_DATE
AND STEP.EFFECTIVE_END_DATE
AND POINT.SPINAL_POINT_ID = STEP.SPINAL_POINT_ID
AND FUSER.USER_ID (+)= GSPINE.LAST_UPDATED_BY

Columns