142: --
143: -- raise error as FK does not relate to PK in ben_rptg_grp
144: -- table.
145: --
146: ben_prb_shd.constraint_error('BEN_PL_REGY_BOD_FK1');
147: --
148: end if;
149: --
150: close c1;
293: --
294: -- raise error as FK does not relate to PK in ben_rptg_grp
295: -- table.
296: --
297: ben_prb_shd.constraint_error('BEN_PL_REGY_BOD_FK1');
298: --
299: end if;
300: --
301: close c1;
807: --
808: cursor csr_leg_code is
809: select a.legislation_code
810: from per_business_groups a,
811: ben_pl_regy_bod_f b
812: where b.pl_regy_bod_id = p_pl_regy_bod_id
813: and a.business_group_id = b.business_group_id;
814: --
815: -- Declare local variables