99: -- Declare cursor
100: --
101: cursor csr_sec_grp is
102: select pbg.security_group_id
103: from per_business_groups pbg
104: , per_previous_employers pem
105: where pem.previous_employer_id = p_previous_employer_id
106: and pbg.business_group_id = pem.business_group_id;
107: --
161: -- Declare cursor
162: --
163: cursor csr_leg_code is
164: select pbg.legislation_code
165: from per_business_groups pbg
166: , per_previous_employers pem
167: where pem.previous_employer_id = p_previous_employer_id
168: and pbg.business_group_id (+) = pem.business_group_id;
169: --