APPS.HR_OFFER_CUSTOM dependencies on PER_JOBS

Line 303: from per_jobs_tl pj

299: l_proc_name varchar2(200) default 'get_vp_name';
300: --
301: cursor csr_papa is
302: select distinct papa.person_id, pj.name
303: from per_jobs_tl pj
304: ,per_assignments pa
305: ,per_assign_proposal_answers papa
306: where pj.job_id = pa.job_id
307: and pj.language=userenv('LANG')

Line 319: from per_jobs_vl pj

315: where person_id = p_person_id;
316: --
317: cursor csr_job (p_person_id in number) is
318: select distinct pj.name
319: from per_jobs_vl pj
320: ,per_assignments pa
321: where pj.job_id = pa.job_id
322: and pa.primary_flag = 'Y'
323: and pa.person_id = p_person_id;

Line 327: l_current_job per_jobs.name%type;

323: and pa.person_id = p_person_id;
324: --
325: l_in_chain boolean := false;
326: l_current_person_id per_people_f.person_id%type;
327: l_current_job per_jobs.name%type;
328: l_person_id per_people_f.person_id%type;
329: l_vp_name varchar(200);
330: l_found_it boolean default FALSE;
331: l_supervisors varchar2(32000);