View: HRFV_US_JOBS

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_US_JOBS

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, '_KF:PER:JOB:JDEF'
, JOBS.DATE_FROM DATE_FROM
, JOBS.DATE_TO DATE_TO
, JOBS.COMMENTS COMMENTS
, HR_BIS.BIS_DECODE_LOOKUP('US_EXEMPT_NON_EXEMPT'
, JOBS.JOB_INFORMATION3) FLSA_CODE
, HR_BIS.BIS_DECODE_LOOKUP('US_EEO1_JOB_CATEGORIES'
, JOBS.JOB_INFORMATION1) EEO_CATEGORY
, JOBS.JOB_INFORMATION2 SURVEY_BENCHMARK
, HR_BIS.BIS_DECODE_LOOKUP('US_JOB_GROUPS'
, JOBS.JOB_INFORMATION4) JOB_GROUP
, JOBS.JOB_INFORMATION5 LINE_OF_PROGRESSION
, JOBS.JOB_INFORMATION6 SALARY_CODE
, '_DF:PER:PER_JOBS:JOBS'
, JOBS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, JOBS.JOB_ID JOB_ID
, JDEF.JOB_DEFINITION_ID JOB_DEFINITION_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_BUSINESS_GROUPS PBG
, PER_JOB_DEFINITIONS JDEF
, PER_JOBS JOBS
WHERE JDEF.JOB_DEFINITION_ID = JOBS.JOB_DEFINITION_ID
AND JOBS.BUSINESS_GROUP_ID = PBG.ORGANIZATION_ID
AND PBG.LEGISLATION_CODE = 'US'
AND JOBS.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND JOBS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, JOBS.BUSINESS_GROUP_ID) WITH READ ONLY

Columns