VIEW: APPS.HRBV_PREVIOUS_JOB_USAGES_V

Source

View Text - Preformatted

SELECT PJU.START_DATE, PJU.END_DATE, PJU.PERIOD_YEARS, PJU.PERIOD_DAYS, PJU.PJU_INFORMATION_CATEGORY, PJU.PJU_INFORMATION1, PJU.PJU_INFORMATION2, PJU.PJU_INFORMATION3, PJU.PJU_INFORMATION4, PJU.PJU_INFORMATION5, PJU.PJU_INFORMATION6, PJU.PJU_INFORMATION7, PJU.PJU_INFORMATION8, PJU.PJU_INFORMATION9, PJU.PJU_INFORMATION10, PJU.PJU_INFORMATION11, PJU.PJU_INFORMATION12, PJU.PJU_INFORMATION13, PJU.PJU_INFORMATION14, PJU.PJU_INFORMATION15, PJU.PJU_INFORMATION16, PJU.PJU_INFORMATION17, PJU.PJU_INFORMATION18, PJU.PJU_INFORMATION19, PJU.PJU_INFORMATION20, PJU.PERIOD_MONTHS, '_DF:PER:PER_PREVIOUS_JOB_USAGES:PJU', PJU.PREVIOUS_JOB_USAGE_ID, PJU.ASSIGNMENT_ID, PJU.PREVIOUS_JOB_ID, PJU.PREVIOUS_EMPLOYER_ID, PJU.LAST_UPDATE_DATE, PJU.LAST_UPDATED_BY, PJU.CREATED_BY, PJU.CREATION_DATE FROM PER_PREVIOUS_JOB_USAGES PJU WITH READ ONLY

View Text - HTML Formatted

SELECT PJU.START_DATE
, PJU.END_DATE
, PJU.PERIOD_YEARS
, PJU.PERIOD_DAYS
, PJU.PJU_INFORMATION_CATEGORY
, PJU.PJU_INFORMATION1
, PJU.PJU_INFORMATION2
, PJU.PJU_INFORMATION3
, PJU.PJU_INFORMATION4
, PJU.PJU_INFORMATION5
, PJU.PJU_INFORMATION6
, PJU.PJU_INFORMATION7
, PJU.PJU_INFORMATION8
, PJU.PJU_INFORMATION9
, PJU.PJU_INFORMATION10
, PJU.PJU_INFORMATION11
, PJU.PJU_INFORMATION12
, PJU.PJU_INFORMATION13
, PJU.PJU_INFORMATION14
, PJU.PJU_INFORMATION15
, PJU.PJU_INFORMATION16
, PJU.PJU_INFORMATION17
, PJU.PJU_INFORMATION18
, PJU.PJU_INFORMATION19
, PJU.PJU_INFORMATION20
, PJU.PERIOD_MONTHS
, '_DF:PER:PER_PREVIOUS_JOB_USAGES:PJU'
, PJU.PREVIOUS_JOB_USAGE_ID
, PJU.ASSIGNMENT_ID
, PJU.PREVIOUS_JOB_ID
, PJU.PREVIOUS_EMPLOYER_ID
, PJU.LAST_UPDATE_DATE
, PJU.LAST_UPDATED_BY
, PJU.CREATED_BY
, PJU.CREATION_DATE
FROM PER_PREVIOUS_JOB_USAGES PJU WITH READ ONLY