275: cursor csr_bg is
276: select legislation_code
277: from per_business_groups pbg
278: where pbg.business_group_id in (select pj.business_group_id 279: from per_jobs_v pj 280: where pj.job_id = p_job_id);
281: --
282: begin
283: hr_utility.set_location('Entering:'|| l_proc, 5);