DBA Data[Home] [Help]

APPS.HR_REPORTS dependencies on PER_JOBS

Line 288: l_job_name per_jobs.name%type;

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;