APPS.BEN_CTY_BUS dependencies on PER_RATING_LEVELS

Line 250: from per_rating_levels a,

246: l_exists varchar2(1);
247: --
248: cursor c1 is
249: select null
250: from per_rating_levels a,
251: per_competences b
252: where b.competence_id = p_competence_id
253: and (a.competence_id = p_competence_id or
254: a.rating_scale_id = b.rating_scale_id )

Line 289: -- check if rating_level_id value exists in per_rating_levels table

285: and nvl(p_competence_id,hr_api.g_number)
286: <> nvl(ben_cty_shd.g_old_rec.rating_level_id,hr_api.g_number)
287: or not l_api_updating) then
288: --
289: -- check if rating_level_id value exists in per_rating_levels table
290: --
291: open c1;
292: --
293: fetch c1 into l_dummy;