SELECT job.job_id ID , job.name VALUE , job.date_from START_DATE , nvl(job.date_to,hr_general.end_of_time) END_DATE , job.business_group_id BUSINESS_GROUP_ID FROM per_jobs job WITH READ ONLY
View Text - HTML Formatted
SELECT JOB.JOB_ID ID , JOB.NAME VALUE , JOB.DATE_FROM START_DATE , NVL(JOB.DATE_TO , HR_GENERAL.END_OF_TIME) END_DATE , JOB.BUSINESS_GROUP_ID BUSINESS_GROUP_ID FROM PER_JOBS JOB WITH READ ONLY