SELECT pj.job_id ID , pj.job_id VALUE , pa_job_utils.get_job_level( pj.job_id, pj.job_group_id) JOB_LEVEL FROM per_jobs pj WHERE pa_job_utils.get_job_level( pj.job_id, pj.job_group_id) IS NOT NULL
View Text - HTML Formatted
SELECT PJ.JOB_ID ID , PJ.JOB_ID VALUE , PA_JOB_UTILS.GET_JOB_LEVEL( PJ.JOB_ID , PJ.JOB_GROUP_ID) JOB_LEVEL FROM PER_JOBS PJ WHERE PA_JOB_UTILS.GET_JOB_LEVEL( PJ.JOB_ID , PJ.JOB_GROUP_ID) IS NOT NULL