85: l_legislation_code varchar2(2);
86: --
87: cursor csr_bg is
88: select legislation_code
89: from per_business_groups pbg
90: where pbg.business_group_id = p_business_group_id;
91: --
92: begin
93: hr_utility.set_location('Entering:'|| l_proc, 5);
272: l_legislation_code varchar2(2);
273: --
274: cursor csr_bg is
275: select legislation_code
276: from per_business_groups pbg
277: where pbg.business_group_id in (select pj.business_group_id
278: from per_jobs_v pj
279: where pj.job_id = p_job_id);
280: --