27: --
28: cursor csr_sec_grp is
29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , per_all_assignments_f paf
33: , per_personal_scorecards pms
34: where pms.scorecard_id = p_scorecard_id
35: and pms.assignment_id = paf.assignment_id
100: -- Declare cursor
101: --
102: cursor csr_leg_code is
103: select pbg.legislation_code
104: from per_business_groups_perf pbg
105: , per_all_assignments_f paf
106: , per_personal_scorecards pms
107: where pms.scorecard_id = p_scorecard_id
108: and pms.assignment_id = paf.assignment_id