View: HR_NUSJOB_LOV_V

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.HR_NUSJOB_LOV_V

View Text

SELECT PJ.JOB_ID
, PJT.NAME JOB_NAME
, PJ.BUSINESS_GROUP_ID
, PJ.DATE_FROM
, PJ.DATE_TO
FROM PER_JOBS_TL PJT
, PER_JOBS PJ
WHERE PJT.JOB_ID = PJ.JOB_ID
AND PJT.LANGUAGE = USERENV('LANG')

Columns