VIEW: APPS.HRBV_PERIODS_OF_PLACEMENT_V

Source

View Text - Preformatted

SELECT PDP.DATE_START, PDP.ACTUAL_TERMINATION_DATE, PDP.PROJECTED_TERMINATION_DATE, PDP.TERMINATION_REASON, HR_BIS.BIS_DECODE_LOOKUP('HR_CWK_TERMINATION_REASONS',PDP.TERMINATION_REASON), PDP.INFORMATION_CATEGORY, PDP.INFORMATION1, PDP.INFORMATION2, PDP.INFORMATION3, PDP.INFORMATION4, PDP.INFORMATION5, PDP.INFORMATION6, PDP.INFORMATION7, PDP.INFORMATION8, PDP.INFORMATION9, PDP.INFORMATION10, PDP.INFORMATION11, PDP.INFORMATION12, PDP.INFORMATION13, PDP.INFORMATION14, PDP.INFORMATION15, PDP.INFORMATION16, PDP.INFORMATION17, PDP.INFORMATION18, PDP.INFORMATION19, PDP.INFORMATION20, PDP.INFORMATION21, PDP.INFORMATION22, PDP.INFORMATION23, PDP.INFORMATION24, PDP.INFORMATION25, PDP.INFORMATION26, PDP.INFORMATION27, PDP.INFORMATION28, PDP.INFORMATION29, PDP.INFORMATION30, PDP.FINAL_PROCESS_DATE, PDP.LAST_STANDARD_PROCESS_DATE, '_DF:PER:PER_PERIODS_OF_PLACEMENT:PDP', PDP.BUSINESS_GROUP_ID, PDP.PERSON_ID, PDP.PERIOD_OF_PLACEMENT_ID, PDP.CREATED_BY, PDP.CREATION_DATE, PDP.LAST_UPDATED_BY, PDP.LAST_UPDATE_DATE, CASE WHEN PDP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PDP.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_PERIODS_OF_PLACEMENT PDP WITH READ ONLY

View Text - HTML Formatted

SELECT PDP.DATE_START
, PDP.ACTUAL_TERMINATION_DATE
, PDP.PROJECTED_TERMINATION_DATE
, PDP.TERMINATION_REASON
, HR_BIS.BIS_DECODE_LOOKUP('HR_CWK_TERMINATION_REASONS'
, PDP.TERMINATION_REASON)
, PDP.INFORMATION_CATEGORY
, PDP.INFORMATION1
, PDP.INFORMATION2
, PDP.INFORMATION3
, PDP.INFORMATION4
, PDP.INFORMATION5
, PDP.INFORMATION6
, PDP.INFORMATION7
, PDP.INFORMATION8
, PDP.INFORMATION9
, PDP.INFORMATION10
, PDP.INFORMATION11
, PDP.INFORMATION12
, PDP.INFORMATION13
, PDP.INFORMATION14
, PDP.INFORMATION15
, PDP.INFORMATION16
, PDP.INFORMATION17
, PDP.INFORMATION18
, PDP.INFORMATION19
, PDP.INFORMATION20
, PDP.INFORMATION21
, PDP.INFORMATION22
, PDP.INFORMATION23
, PDP.INFORMATION24
, PDP.INFORMATION25
, PDP.INFORMATION26
, PDP.INFORMATION27
, PDP.INFORMATION28
, PDP.INFORMATION29
, PDP.INFORMATION30
, PDP.FINAL_PROCESS_DATE
, PDP.LAST_STANDARD_PROCESS_DATE
, '_DF:PER:PER_PERIODS_OF_PLACEMENT:PDP'
, PDP.BUSINESS_GROUP_ID
, PDP.PERSON_ID
, PDP.PERIOD_OF_PLACEMENT_ID
, PDP.CREATED_BY
, PDP.CREATION_DATE
, PDP.LAST_UPDATED_BY
, PDP.LAST_UPDATE_DATE
, CASE WHEN PDP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PDP.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_PERIODS_OF_PLACEMENT PDP WITH READ ONLY