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;