APPS.BEN_CCM_BUS dependencies on BEN_COMP_LVL_FCTR

Line 299: from ben_comp_lvl_fctr a

295: l_dummy varchar2(1);
296: --
297: cursor c1 is
298: select null
299: from ben_comp_lvl_fctr a
300: where a.comp_lvl_fctr_id = p_comp_lvl_fctr_id;
301: --
302: Begin
303: --

Line 317: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table

313: <> nvl(ben_ccm_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
314: or not l_api_updating) and
315: p_comp_lvl_fctr_id is not null then
316: --
317: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table
318: --
319: open c1;
320: --
321: fetch c1 into l_dummy;

Line 326: -- raise error as FK does not relate to PK in ben_comp_lvl_fctr

322: if c1%notfound then
323: --
324: close c1;
325: --
326: -- raise error as FK does not relate to PK in ben_comp_lvl_fctr
327: -- table.
328: --
329: ben_ccm_shd.constraint_error('BEN_CVG_AMT_CALC_MTHD_FK2');
330: --