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: , pqh_corps_definitions cpd
33: where cpd.corps_definition_id = p_corps_definition_id
34: and pbg.business_group_id = cpd.business_group_id;
35: --
102: -- Declare cursor
103: --
104: cursor csr_leg_code is
105: select pbg.legislation_code
106: from per_business_groups_perf pbg
107: , pqh_corps_definitions cpd
108: where cpd.corps_definition_id = p_corps_definition_id
109: and pbg.business_group_id = cpd.business_group_id;
110: --