370: -- Declare cursor
371: --
372: cursor csr_sec_grp is
373: select pbg.security_group_id
374: from per_business_groups pbg
375: , ben_pl_pcp_typ pty
376: where pty.pl_pcp_typ_id = p_pl_pcp_typ_id
377: and pbg.business_group_id = pty.business_group_id;
378: --
430: -- Declare cursor
431: --
432: cursor csr_leg_code is
433: select pbg.legislation_code
434: from per_business_groups pbg
435: , ben_pl_pcp_typ pty
436: where pty.pl_pcp_typ_id = p_pl_pcp_typ_id
437: and pbg.business_group_id = pty.business_group_id;
438: --