DBA Data[Home] [Help]

APPS.PO_SERVICES_PVT dependencies on PER_JOBS_VL

Line 339: l_job_name PER_JOBS_VL.name%TYPE;

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: