APPS.BEN_ECY_BUS dependencies on PER_RATING_LEVELS

Line 207: , per_rating_levels rtl

203: --
204: cursor c1 is
205: select null
206: from per_competences cmp
207: , per_rating_levels rtl
208: where nvl(cmp.business_group_id, p_business_group_id) = p_business_group_id
209: and p_effective_date between nvl(cmp.date_from, p_effective_date) and nvl(cmp.date_to, p_effective_date)
210: and nvl(rtl.business_group_id, p_business_group_id) = p_business_group_id
211: and ( (rtl.competence_id is not null

Line 240: -- per_rating_levels table

236: or not l_api_updating)
237: and p_rating_level_id is not null then
238: --
239: -- check if rating_level_id value exists in
240: -- per_rating_levels table
241: --
242: open c1;
243: --
244: fetch c1 into l_dummy;

Line 250: -- per_rating_levels table.

246: --
247: 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;