DBA Data[Home] [Help]

APPS.HR_OFFER_CUSTOM dependencies on PER_JOBS_TL

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')