26: -- Declare cursor
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
94: -- Declare cursor
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