335: -------------------------------------------------------------------------------
336: FUNCTION get_job_name ( p_job_id IN NUMBER )
337: RETURN VARCHAR2
338: IS 339: l_job_name PER_JOBS_VL.name%TYPE; 340: BEGIN
341:
342: IF ( p_job_id IS NULL )
343: THEN
Line 349: FROM per_jobs_vl
345: END IF;
346:
347: SELECT name
348: INTO l_job_name 349: FROM per_jobs_vl 350: WHERE job_id = p_job_id;
351:
352: return (l_job_name);
353: