445: --
446: cursor csr_sec_grp is
447: select pbg.security_group_id,
448: pbg.legislation_code
449: from per_business_groups_perf pbg,
450: ota_finance_headers tfh,
451: hr_all_organization_units org
452: where pbg.business_group_id = org.business_group_id
453: and org.organization_id = tfh.organization_id
544: -- Declare cursor
545: --
546: cursor csr_leg_code is
547: select legislation_code
548: from per_business_groups_perf pbg,
549: ota_finance_headers tfh,
550: hr_all_organization_units org
551: where pbg.business_group_id = org.business_group_id
552: and org.organization_id = tfh.organization_id