27: --
28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , per_jobs_tl jbt
32: , per_jobs job
33: where jbt.job_id = p_job_id
34: and jbt.job_id = job.job_id
35: and pbg.business_group_id = job.business_group_id;
28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , per_jobs_tl jbt
32: , per_jobs job
33: where jbt.job_id = p_job_id
34: and jbt.job_id = job.job_id
35: and pbg.business_group_id = job.business_group_id;
36: --
95: --
96: cursor csr_leg_code is
97: select pbg.legislation_code
98: from per_business_groups pbg
99: , per_jobs_tl jbt
100: , per_jobs job
101: where jbt.job_id = p_job_id
102: and jbt.job_id = job.job_id
103: and pbg.business_group_id = job.business_group_id;
96: cursor csr_leg_code is
97: select pbg.legislation_code
98: from per_business_groups pbg
99: , per_jobs_tl jbt
100: , per_jobs job
101: where jbt.job_id = p_job_id
102: and jbt.job_id = job.job_id
103: and pbg.business_group_id = job.business_group_id;
104: --