190: --
191: --
192: cursor csr_organization_id is
193: select null
194: from ben_regn_for_regy_body_f
195: where organization_id = p_organization_id
196: and regn_id = p_regn_id
197: and regn_for_regy_body_id <> nvl(p_regn_for_regy_body_id,hr_api.g_number)
198: and business_group_id + 0 = p_business_group_id
575: --
576: cursor csr_leg_code is
577: select a.legislation_code
578: from per_business_groups a,
579: ben_regn_for_regy_body_f b
580: where b.regn_for_regy_body_id = p_regn_for_regy_body_id
581: and a.business_group_id = b.business_group_id;
582: --
583: -- Declare local variables