Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_GRADE_SPINES_V |
SELECT GRS.ROWID
, GRS.GRADE_SPINE_ID
, GRS.EFFECTIVE_START_DATE
, GRS.EFFECTIVE_END_DATE
, GRS.BUSINESS_GROUP_ID
, GRS.PARENT_SPINE_ID
, GRS.GRADE_ID
, GRS.CEILING_STEP_ID
, GRS.REQUEST_ID
, GRS.PROGRAM_APPLICATION_ID
, GRS.PROGRAM_ID
, GRS.PROGRAM_UPDATE_DATE
, GRS.LAST_UPDATE_DATE
, GRS.LAST_UPDATED_BY
, GRS.LAST_UPDATE_LOGIN
, GRS.CREATED_BY
, GRS.CREATION_DATE
, GDT.NAME
, PS.NAME
, PSP.SPINAL_POINT
, PSP.SPINAL_POINT_ID
, PSP.SEQUENCE
, GRS.OBJECT_VERSION_NUMBER
FROM PER_GRADE_SPINES_F GRS
, PER_GRADES_TL GDT
, PER_PARENT_SPINES PS
, PER_SPINAL_POINTS PSP
, PER_SPINAL_POINT_STEPS S1
, FND_SESSIONS FND
WHERE GRS.GRADE_ID = GDT.GRADE_ID
AND GDT.LANGUAGE = USERENV('LANG')
AND GRS.PARENT_SPINE_ID = PS.PARENT_SPINE_ID
AND PSP.PARENT_SPINE_ID = PS.PARENT_SPINE_ID
AND S1.SPINAL_POINT_ID = PSP.SPINAL_POINT_ID
AND S1.STEP_ID = GRS.CEILING_STEP_ID
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN S1.EFFECTIVE_START_DATE
AND S1.EFFECTIVE_END_DATE
AND FND.EFFECTIVE_DATE BETWEEN GRS.EFFECTIVE_START_DATE
AND GRS.EFFECTIVE_END_DATE