APPS.BEN_CTY_BUS dependencies on PER_COMPETENCES

Line 129: from per_competences a

125: l_exists varchar2(1);
126: --
127: cursor c1 is
128: select null
129: from per_competences a
130: where a.competence_id = p_competence_id
131: and nvl(a.business_group_id, p_business_group_id) = p_business_group_id
132: and p_effective_date between a.date_from and
133: nvl(a.date_to, p_effective_date);

Line 163: -- check if competence_id value exists in per_competences table

159: and nvl(p_competence_id,hr_api.g_number)
160: <> nvl(ben_cty_shd.g_old_rec.competence_id,hr_api.g_number)
161: or not l_api_updating) then
162: --
163: -- check if competence_id value exists in per_competences table
164: --
165: open c1;
166: --
167: fetch c1 into l_dummy;

Line 251: per_competences b

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 )
255: and a.rating_level_id = p_rating_level_id