357: cursor csr_bg is
358: select p.business_group_id
359: ,j.business_group_id
360: from per_all_people_f p
361: ,per_job_groups j
362: where p.person_id = p_person_id
363: and j.job_group_id = p_job_group_id;
364: --
365: cursor csr_valid_job_group is
363: and j.job_group_id = p_job_group_id;
364: --
365: cursor csr_valid_job_group is
366: select 'X'
367: from per_job_groups
368: where job_group_id = p_job_group_id
369: and internal_name <> 'HR_'||business_group_id;
370: --
371: cursor csr_job_in_jgr is