259: --
260: cursor csr_sec_grp is
261: select pbg.security_group_id,
262: pbg.legislation_code
263: from per_business_groups pbg
264: , ota_events evt
265: where evt.event_id = p_event_id
266: and pbg.business_group_id = evt.business_group_id ;
267:
333: -- Declare cursor
334: --
335: cursor csr_leg_code is
336: select pbg.legislation_code
337: from per_business_groups pbg
338: , ota_events_tl ent
339: , ota_events evt
340: where ent.event_id = p_event_id
341: and ent.language = p_language