DBA Data[Home] [Help]

APPS.BEN_CLA_BUS dependencies on BEN_LOS_FCTR

Line 186: from ben_los_fctr a

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: --

Line 202: -- check if los_fctr_id value exists in ben_los_fctr table

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;

Line 211: -- raise error as FK does not relate to PK in ben_los_fctr

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: --