284: FUNCTION get_job
285: (p_job_id NUMBER) return VARCHAR2
286: --
287: AS 288: l_job_name per_jobs.name%type; 289: --
290: begin
291: --
292: hr_utility.trace('Entered Get_Job');
Line 298: FROM per_jobs_vl
294: begin
295: hr_utility.set_location('hr_reports.get_job',5);
296: SELECT name
297: INTO l_job_name 298: FROM per_jobs_vl 299: WHERE job_id = p_job_id;
300: --
301: exception when NO_DATA_FOUND then null;
302: end;