Line 215: ben_cpy_shd.constraint_error('BEN_PL_REGN_FK2');
211: --
212: -- raise error as FK does not relate to PK in ben_rptg_grp
213: -- table.
214: -- 215: ben_cpy_shd.constraint_error('BEN_PL_REGN_FK2'); 216: --
217: end if;
218: --
219: close c1;
Line 1259: ben_pl_regn_f b
1255: --
1256: cursor csr_leg_code is
1257: select a.legislation_code
1258: from per_business_groups a, 1259: ben_pl_regn_f b 1260: where b.pl_regn_id = p_pl_regn_id
1261: and a.business_group_id = b.business_group_id;
1262: --
1263: -- Declare local variables