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