APPS.BEN_ECY_BUS dependencies on PER_COMPETENCES

Line 117: from per_competences cmp

113: l_dummy varchar2(1);
114: --
115: cursor c1 is
116: select null
117: from per_competences cmp
118: where cmp.competence_id = p_competence_id
119: and nvl(cmp.business_group_id,p_business_group_id) = p_business_group_id
120: and p_effective_date between nvl(date_from, p_effective_date) and nvl(date_to, p_effective_date);
121: --

Line 142: -- per_competences table

138: or not l_api_updating)
139: and p_competence_id is not null then
140: --
141: -- check if competence_id value exists in
142: -- per_competences table
143: --
144: open c1;
145: --
146: fetch c1 into l_dummy;

Line 152: -- per_competences table.

148: --
149: close c1;
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;

Line 206: from per_competences cmp

202: l_dummy varchar2(1);
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