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')