150: --
151: -- raise error as FK does not relate to PK in
152: -- per_competences table.
153: --
154: ben_ecy_shd.constraint_error('BEN_ELIG_COMPTNCY_PRTE_F_FK1');
155: --
156: end if;
157: --
158: close c1;
248: --
249: -- raise error as FK does not relate to PK in
250: -- per_rating_levels table.
251: --
252: ben_ecy_shd.constraint_error('BEN_ELIG_COMPTNCY_PRTE_F_FK2');
253: --
254: end if;
255: --
256: close c1;
366: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
367: l_dummy char(1);
368: cursor c1 is
369: select null
370: from ben_ELIG_COMPTNCY_PRTE_f
371: where ELIG_COMPTNCY_PRTE_id <> nvl(p_ELIG_COMPTNCY_PRTE_id,-1)
372: and eligy_prfl_id = p_eligy_prfl_id
373: and ordr_num = p_ordr_num
374: and business_group_id = p_business_group_id;
744: --
745: cursor csr_leg_code is
746: select a.legislation_code
747: from per_business_groups a,
748: ben_ELIG_COMPTNCY_PRTE_f b
749: where b.ELIG_COMPTNCY_PRTE_id = p_ELIG_COMPTNCY_PRTE_id
750: and a.business_group_id = b.business_group_id;
751: --
752: -- Declare local variables