25: -- Declare cursor
26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups_perf pbg
30: , per_calendar_entries ent
31: , per_cal_entry_values env
32: where env.cal_entry_value_id = p_cal_entry_value_id
33: and env.calendar_entry_id = ent.calendar_entry_id
92: -- Declare cursor
93: --
94: cursor csr_leg_code is
95: select pbg.legislation_code
96: from per_business_groups_perf pbg
97: , per_calendar_entries ent
98: , per_cal_entry_values env
99: where env.cal_entry_value_id = p_cal_entry_value_id
100: and env.calendar_entry_id = ent.calendar_entry_id