VIEW: APPS.HRBV_PREVIOUS_JOBS_V

Source

View Text - Preformatted

SELECT PJO.START_DATE, PJO.END_DATE, PJO.PERIOD_YEARS, PJO.PERIOD_DAYS, PJO.JOB_NAME, PJO.EMPLOYMENT_CATEGORY, HR_BIS.BIS_DECODE_LOOKUP('EMPLOYEE_CATG',PJO.EMPLOYMENT_CATEGORY), PJO.DESCRIPTION, PJO.PJO_INFORMATION_CATEGORY, PJO.PJO_INFORMATION1, PJO.PJO_INFORMATION2, PJO.PJO_INFORMATION3, PJO.PJO_INFORMATION4, PJO.PJO_INFORMATION5, PJO.PJO_INFORMATION6, PJO.PJO_INFORMATION7, PJO.PJO_INFORMATION8, PJO.PJO_INFORMATION9, PJO.PJO_INFORMATION10, PJO.PJO_INFORMATION11, PJO.PJO_INFORMATION12, PJO.PJO_INFORMATION13, PJO.PJO_INFORMATION14, PJO.PJO_INFORMATION15, PJO.PJO_INFORMATION16, PJO.PJO_INFORMATION17, PJO.PJO_INFORMATION18, PJO.PJO_INFORMATION19, PJO.PJO_INFORMATION20, PJO.PJO_INFORMATION21, PJO.PJO_INFORMATION22, PJO.PJO_INFORMATION23, PJO.PJO_INFORMATION24, PJO.PJO_INFORMATION25, PJO.PJO_INFORMATION26, PJO.PJO_INFORMATION27, PJO.PJO_INFORMATION28, PJO.PJO_INFORMATION29, PJO.PJO_INFORMATION30, PJO.ALL_ASSIGNMENTS, HR_BIS.BIS_DECODE_LOOKUP('YES_NO', PJO.ALL_ASSIGNMENTS), PJO.PERIOD_MONTHS, '_DF:PER:PER_PREVIOUS_JOBS:PJO', PJO.PREVIOUS_JOB_ID, PJO.PREVIOUS_EMPLOYER_ID, PJO.LAST_UPDATE_DATE, PJO.LAST_UPDATED_BY, PJO.CREATED_BY, PJO.CREATION_DATE FROM PER_PREVIOUS_JOBS PJO WITH READ ONLY

View Text - HTML Formatted

SELECT PJO.START_DATE
, PJO.END_DATE
, PJO.PERIOD_YEARS
, PJO.PERIOD_DAYS
, PJO.JOB_NAME
, PJO.EMPLOYMENT_CATEGORY
, HR_BIS.BIS_DECODE_LOOKUP('EMPLOYEE_CATG'
, PJO.EMPLOYMENT_CATEGORY)
, PJO.DESCRIPTION
, PJO.PJO_INFORMATION_CATEGORY
, PJO.PJO_INFORMATION1
, PJO.PJO_INFORMATION2
, PJO.PJO_INFORMATION3
, PJO.PJO_INFORMATION4
, PJO.PJO_INFORMATION5
, PJO.PJO_INFORMATION6
, PJO.PJO_INFORMATION7
, PJO.PJO_INFORMATION8
, PJO.PJO_INFORMATION9
, PJO.PJO_INFORMATION10
, PJO.PJO_INFORMATION11
, PJO.PJO_INFORMATION12
, PJO.PJO_INFORMATION13
, PJO.PJO_INFORMATION14
, PJO.PJO_INFORMATION15
, PJO.PJO_INFORMATION16
, PJO.PJO_INFORMATION17
, PJO.PJO_INFORMATION18
, PJO.PJO_INFORMATION19
, PJO.PJO_INFORMATION20
, PJO.PJO_INFORMATION21
, PJO.PJO_INFORMATION22
, PJO.PJO_INFORMATION23
, PJO.PJO_INFORMATION24
, PJO.PJO_INFORMATION25
, PJO.PJO_INFORMATION26
, PJO.PJO_INFORMATION27
, PJO.PJO_INFORMATION28
, PJO.PJO_INFORMATION29
, PJO.PJO_INFORMATION30
, PJO.ALL_ASSIGNMENTS
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PJO.ALL_ASSIGNMENTS)
, PJO.PERIOD_MONTHS
, '_DF:PER:PER_PREVIOUS_JOBS:PJO'
, PJO.PREVIOUS_JOB_ID
, PJO.PREVIOUS_EMPLOYER_ID
, PJO.LAST_UPDATE_DATE
, PJO.LAST_UPDATED_BY
, PJO.CREATED_BY
, PJO.CREATION_DATE
FROM PER_PREVIOUS_JOBS PJO WITH READ ONLY