VIEW: APPS.HRBV_SPINAL_POINT_PLACEMENTS_V

Source

View Text - Preformatted

SELECT SPP.EFFECTIVE_START_DATE, SPP.EFFECTIVE_END_DATE, SPP.REASON, HR_BIS.BIS_DECODE_LOOKUP('PLACEMENT_REASON',SPP.REASON), SPP.PROGRAM_UPDATE_DATE, SPP.INCREMENT_NUMBER, SPP.INFORMATION1, SPP.INFORMATION2, SPP.INFORMATION3, SPP.INFORMATION4, SPP.INFORMATION5, SPP.INFORMATION6, SPP.INFORMATION7, SPP.INFORMATION8, SPP.INFORMATION9, SPP.INFORMATION10, SPP.INFORMATION11, SPP.INFORMATION12, SPP.INFORMATION13, SPP.INFORMATION14, SPP.INFORMATION15, SPP.INFORMATION16, SPP.INFORMATION17, SPP.INFORMATION18, SPP.INFORMATION19, SPP.INFORMATION20, SPP.INFORMATION21, SPP.INFORMATION22, SPP.INFORMATION23, SPP.INFORMATION24, SPP.INFORMATION25, SPP.INFORMATION26, SPP.INFORMATION27, SPP.INFORMATION28, SPP.INFORMATION29, SPP.INFORMATION30, SPP.INFORMATION_CATEGORY, SPP.AUTO_INCREMENT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',SPP.AUTO_INCREMENT_FLAG), HR_API.RETURN_LEGISLATION_CODE(SPP.BUSINESS_GROUP_ID), SPP.PLACEMENT_ID, SPP.BUSINESS_GROUP_ID, SPP.ASSIGNMENT_ID, SPP.STEP_ID, SPP.PARENT_SPINE_ID, SPP.LAST_UPDATE_DATE, SPP.LAST_UPDATED_BY, SPP.CREATED_BY, SPP.CREATION_DATE, CASE WHEN SPP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, SPP.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_SPINAL_POINT_PLACEMENTS_F SPP WITH READ ONLY

View Text - HTML Formatted

SELECT SPP.EFFECTIVE_START_DATE
, SPP.EFFECTIVE_END_DATE
, SPP.REASON
, HR_BIS.BIS_DECODE_LOOKUP('PLACEMENT_REASON'
, SPP.REASON)
, SPP.PROGRAM_UPDATE_DATE
, SPP.INCREMENT_NUMBER
, SPP.INFORMATION1
, SPP.INFORMATION2
, SPP.INFORMATION3
, SPP.INFORMATION4
, SPP.INFORMATION5
, SPP.INFORMATION6
, SPP.INFORMATION7
, SPP.INFORMATION8
, SPP.INFORMATION9
, SPP.INFORMATION10
, SPP.INFORMATION11
, SPP.INFORMATION12
, SPP.INFORMATION13
, SPP.INFORMATION14
, SPP.INFORMATION15
, SPP.INFORMATION16
, SPP.INFORMATION17
, SPP.INFORMATION18
, SPP.INFORMATION19
, SPP.INFORMATION20
, SPP.INFORMATION21
, SPP.INFORMATION22
, SPP.INFORMATION23
, SPP.INFORMATION24
, SPP.INFORMATION25
, SPP.INFORMATION26
, SPP.INFORMATION27
, SPP.INFORMATION28
, SPP.INFORMATION29
, SPP.INFORMATION30
, SPP.INFORMATION_CATEGORY
, SPP.AUTO_INCREMENT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, SPP.AUTO_INCREMENT_FLAG)
, HR_API.RETURN_LEGISLATION_CODE(SPP.BUSINESS_GROUP_ID)
, SPP.PLACEMENT_ID
, SPP.BUSINESS_GROUP_ID
, SPP.ASSIGNMENT_ID
, SPP.STEP_ID
, SPP.PARENT_SPINE_ID
, SPP.LAST_UPDATE_DATE
, SPP.LAST_UPDATED_BY
, SPP.CREATED_BY
, SPP.CREATION_DATE
, CASE WHEN SPP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, SPP.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_SPINAL_POINT_PLACEMENTS_F SPP WITH READ ONLY