[Home] [Help]
View: HR_JOBS_LOV_V
Product: | PER - Human Resources |
Description: | HR Web Offers List of Values view |
Implementation/DBA Data: |
APPS.HR_JOBS_LOV_V
|
View Text
SELECT JOB. JOB_ID
, JOB.BUSINESS_GROUP_ID
, JOB.DATE_FROM
, JOB.DATE_TO
, JBT.NAME
FROM PER_JOBS_TL JBT
, PER_JOBS JOB
WHERE JBT.JOB_ID = JOB.JOB_ID
AND JBT.LANGUAGE = USERENV('LANG')
Columns
Name |
JOB_ID |
BUSINESS_GROUP_ID |
DATE_FROM |
DATE_TO |
NAME |