VIEW: APPS.HR_NUSJOB_BASE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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