[Home] [Help]
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
Name |
BUSINESS_GROUP_NAME |
"_KF:JOB_NAME" |
DATE_FROM |
DATE_TO |
COMMENTS |
FLSA_CODE |
EEO_CATEGORY |
SURVEY_BENCHMARK |
JOB_GROUP |
LINE_OF_PROGRESSION |
SALARY_CODE |
"_DF" |
BUSINESS_GROUP_ID |
JOB_ID |
JOB_DEFINITION_ID |