[Home] [Help]
166: -- Declare cursor
167: --
168: cursor csr_sec_grp is
169: select pbg.security_group_id
170: from per_business_groups pbg,
171: per_recruitment_activities pra
172: where
173: pra.recruitment_activity_id = p_recruitment_activity_id
174: and pra.business_group_id = pbg.business_group_id;