Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_SPINAL_POINT_STEPS_V |
SELECT SPS.ROWID
, SPS.STEP_ID
, SPS.EFFECTIVE_START_DATE
, SPS.EFFECTIVE_END_DATE
, SPS.BUSINESS_GROUP_ID
, SPS.SPINAL_POINT_ID
, SPS.GRADE_SPINE_ID
, SPS.SEQUENCE
, SPS.REQUEST_ID
, SPS.PROGRAM_APPLICATION_ID
, SPS.PROGRAM_ID
, SPS.PROGRAM_UPDATE_DATE
, SPS.LAST_UPDATE_DATE
, SPS.LAST_UPDATED_BY
, SPS.LAST_UPDATE_LOGIN
, SPS.CREATED_BY
, SPS.CREATION_DATE
, SP.SPINAL_POINT
, SPS.INFORMATION1
, SPS.INFORMATION2
, SPS.INFORMATION3
, SPS.INFORMATION4
, SPS.INFORMATION5
, SPS.INFORMATION6
, SPS.INFORMATION7
, SPS.INFORMATION8
, SPS.INFORMATION9
, SPS.INFORMATION10
, SPS.INFORMATION11
, SPS.INFORMATION12
, SPS.INFORMATION13
, SPS.INFORMATION14
, SPS.INFORMATION15
, SPS.INFORMATION16
, SPS.INFORMATION17
, SPS.INFORMATION18
, SPS.INFORMATION19
, SPS.INFORMATION20
, SPS.INFORMATION21
, SPS.INFORMATION22
, SPS.INFORMATION23
, SPS.INFORMATION24
, SPS.INFORMATION25
, SPS.INFORMATION26
, SPS.INFORMATION27
, SPS.INFORMATION28
, SPS.INFORMATION29
, SPS.INFORMATION30
, SPS.INFORMATION_CATEGORY
FROM PER_SPINAL_POINT_STEPS_F SPS
, PER_SPINAL_POINTS SP
, FND_SESSIONS FND
WHERE SPS.SPINAL_POINT_ID = SP.SPINAL_POINT_ID
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN SPS.EFFECTIVE_START_DATE
AND SPS.EFFECTIVE_END_DATE