805: -- Declare cursor
806: --
807: cursor csr_sec_grp is
808: select pbg.security_group_id
809: from per_business_groups pbg
810: , ben_pl_pcp pcp
811: where pcp.pl_pcp_id = p_pl_pcp_id
812: and pbg.business_group_id = pcp.business_group_id;
813: --
865: -- Declare cursor
866: --
867: cursor csr_leg_code is
868: select pbg.legislation_code
869: from per_business_groups pbg
870: , ben_pl_pcp pcp
871: where pcp.pl_pcp_id = p_pl_pcp_id
872: and pbg.business_group_id = pcp.business_group_id;
873: --