APPS.HR_MISC_WEB dependencies on PER_JOBS

Line 292: p_job_name IN per_jobs.name%TYPE DEFAULT NULL,

288: */
289:
290: FUNCTION get_user_defined_job_segments
291: ( p_job_segments IN varchar2 DEFAULT NULL,
292: p_job_name IN per_jobs.name%TYPE DEFAULT NULL,
293: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL)
294: RETURN VARCHAR2
295: IS
296:

Line 293: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL)

289:
290: FUNCTION get_user_defined_job_segments
291: ( p_job_segments IN varchar2 DEFAULT NULL,
292: p_job_name IN per_jobs.name%TYPE DEFAULT NULL,
293: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL)
294: RETURN VARCHAR2
295: IS
296:
297: v_BlockStr VARCHAR2(500);

Line 316: ' FROM per_job_definitions pjd, per_jobs pj ' ||

312:
313: job_select_segments := replace(p_job_segments,'|','||''.''||');
314:
315: v_BlockStr := ' SELECT ' || job_select_segments ||
316: ' FROM per_job_definitions pjd, per_jobs pj ' ||
317: ' WHERE pjd.job_definition_id = pj.job_definition_id ' ||
318: ' AND pj.job_id = :1';
319:
320: -- Fix 3666171.

Line 568: FROM per_jobs_vl pj,

564: p_effective_date IN DATE
565: ) IS
566: SELECT pj.job_id,
567: pj.name
568: FROM per_jobs_vl pj,
569: per_all_assignments_f paf
570: WHERE paf.assignment_id = p_assignment_id
571: AND paf.job_id = pj.job_id
572: -- AND paf.primary_flag = 'Y' -- To supprot multiple assignments