[Home] [Help]
VIEW: APPS.HR_JOBS_LOV_V
Source
View Text - Preformatted
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')
View Text - HTML Formatted
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')