DBA Data[Home] [Help]

APPS.HR_OFFER_CUSTOM dependencies on PER_JOBS_VL

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;