182: l_dummy varchar2(1);
183: --
184: cursor c1 is
185: select null
186: from ben_los_fctr a
187: where a.los_fctr_id = p_los_fctr_id;
188: --
189: Begin
190: --
198: and nvl(p_los_fctr_id,hr_api.g_number)
199: <> nvl(ben_cla_shd.g_old_rec.los_fctr_id,hr_api.g_number)
200: or not l_api_updating) then
201: --
202: -- check if los_fctr_id value exists in ben_los_fctr table
203: --
204: open c1;
205: --
206: fetch c1 into l_dummy;
207: if c1%notfound then
208: --
209: close c1;
210: --
211: -- raise error as FK does not relate to PK in ben_los_fctr
212: -- table.
213: --
214: ben_cla_shd.constraint_error('BEN_CMB_AGE_LGH_OF_SVC_FCT_FK2');
215: --