VIEW: APPS.HRBV_JOB

Source

View Text - Preformatted

SELECT jbt.name name ,'_KF:PER:JOB:jdef' ,jobs.date_from date_from ,jobs.date_to date_to ,jobs.comments comments ,hr_bis.bis_decode_lookup('YES_NO',jobs.benchmark_job_flag) benchmark_job_flag ,hr_bis.bis_decode_lookup('YES_NO',jobs.emp_rights_flag) emp_rights_flag ,jobs.approval_authority approval_authority ,jobs.job_information_category job_information_category ,jobs.job_information1 job_information1 ,jobs.job_information2 job_information2 ,jobs.job_information3 job_information3 ,jobs.job_information4 job_information4 ,jobs.job_information5 job_information5 ,jobs.job_information6 job_information6 ,jobs.job_information7 job_information7 ,jobs.job_information8 job_information8 ,jobs.job_information9 job_information9 ,jobs.job_information10 job_information10 ,jobs.job_information11 job_information11 ,jobs.job_information12 job_information12 ,jobs.job_information13 job_information13 ,jobs.job_information14 job_information14 ,jobs.job_information15 job_information15 ,jobs.job_information16 job_information16 ,jobs.job_information17 job_information17 ,jobs.job_information18 job_information18 ,jobs.job_information19 job_information19 ,jobs.job_information20 job_information20 ,'_DF:PER:PER_JOBS:jobs' ,jobs.benchmark_job_flag benchmark_job_flag_code ,jobs.emp_rights_flag emp_rights_flag_code ,hr_api.return_legislation_code(jobs.business_group_id) legislation_code ,jobs.business_group_id business_group_id ,jobs.job_id job_id ,jobs.job_definition_id job_definition_id ,jobs.job_group_id job_group_id ,jobs.benchmark_job_id benchmark_job_id ,jobs.last_update_date last_update_date ,jobs.last_updated_by last_updated_by ,jobs.last_update_login last_update_login ,jobs.created_by created_by ,jobs.creation_date creation_date ,CASE WHEN (jobs.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, jobs.business_group_id)) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM per_jobs jobs ,per_jobs_tl jbt ,per_job_definitions jdef WHERE jobs.job_id = jbt.job_id AND jbt.language = userenv('LANG') AND jobs.job_definition_id = jdef.job_definition_id WITH READ ONLY

View Text - HTML Formatted

SELECT JBT.NAME NAME
, '_KF:PER:JOB:JDEF'
, JOBS.DATE_FROM DATE_FROM
, JOBS.DATE_TO DATE_TO
, JOBS.COMMENTS COMMENTS
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, JOBS.BENCHMARK_JOB_FLAG) BENCHMARK_JOB_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, JOBS.EMP_RIGHTS_FLAG) EMP_RIGHTS_FLAG
, JOBS.APPROVAL_AUTHORITY APPROVAL_AUTHORITY
, JOBS.JOB_INFORMATION_CATEGORY JOB_INFORMATION_CATEGORY
, JOBS.JOB_INFORMATION1 JOB_INFORMATION1
, JOBS.JOB_INFORMATION2 JOB_INFORMATION2
, JOBS.JOB_INFORMATION3 JOB_INFORMATION3
, JOBS.JOB_INFORMATION4 JOB_INFORMATION4
, JOBS.JOB_INFORMATION5 JOB_INFORMATION5
, JOBS.JOB_INFORMATION6 JOB_INFORMATION6
, JOBS.JOB_INFORMATION7 JOB_INFORMATION7
, JOBS.JOB_INFORMATION8 JOB_INFORMATION8
, JOBS.JOB_INFORMATION9 JOB_INFORMATION9
, JOBS.JOB_INFORMATION10 JOB_INFORMATION10
, JOBS.JOB_INFORMATION11 JOB_INFORMATION11
, JOBS.JOB_INFORMATION12 JOB_INFORMATION12
, JOBS.JOB_INFORMATION13 JOB_INFORMATION13
, JOBS.JOB_INFORMATION14 JOB_INFORMATION14
, JOBS.JOB_INFORMATION15 JOB_INFORMATION15
, JOBS.JOB_INFORMATION16 JOB_INFORMATION16
, JOBS.JOB_INFORMATION17 JOB_INFORMATION17
, JOBS.JOB_INFORMATION18 JOB_INFORMATION18
, JOBS.JOB_INFORMATION19 JOB_INFORMATION19
, JOBS.JOB_INFORMATION20 JOB_INFORMATION20
, '_DF:PER:PER_JOBS:JOBS'
, JOBS.BENCHMARK_JOB_FLAG BENCHMARK_JOB_FLAG_CODE
, JOBS.EMP_RIGHTS_FLAG EMP_RIGHTS_FLAG_CODE
, HR_API.RETURN_LEGISLATION_CODE(JOBS.BUSINESS_GROUP_ID) LEGISLATION_CODE
, JOBS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, JOBS.JOB_ID JOB_ID
, JOBS.JOB_DEFINITION_ID JOB_DEFINITION_ID
, JOBS.JOB_GROUP_ID JOB_GROUP_ID
, JOBS.BENCHMARK_JOB_ID BENCHMARK_JOB_ID
, JOBS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JOBS.LAST_UPDATED_BY LAST_UPDATED_BY
, JOBS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, JOBS.CREATED_BY CREATED_BY
, JOBS.CREATION_DATE CREATION_DATE
, CASE WHEN (JOBS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, JOBS.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_JOBS JOBS
, PER_JOBS_TL JBT
, PER_JOB_DEFINITIONS JDEF
WHERE JOBS.JOB_ID = JBT.JOB_ID
AND JBT.LANGUAGE = USERENV('LANG')
AND JOBS.JOB_DEFINITION_ID = JDEF.JOB_DEFINITION_ID WITH READ ONLY