DBA Data[Home] [Help]

APPS.BEN_CQB_BUS dependencies on BEN_PL_TYP_F

Line 262: from ben_pl_typ_f a

258: l_dummy varchar2(1);
259: --
260: cursor c1 is
261: select null
262: from ben_pl_typ_f a
263: where a.pl_typ_id = p_pl_typ_id;
264: --
265: Begin
266: --

Line 279: -- check if pl_typ_id value exists in ben_pl_typ_f table

275: <> nvl(ben_cqb_shd.g_old_rec.pl_typ_id,hr_api.g_number)
276: or not l_api_updating) and
277: p_pl_typ_id is not null then
278: --
279: -- check if pl_typ_id value exists in ben_pl_typ_f table
280: --
281: open c1;
282: --
283: fetch c1 into l_dummy;

Line 288: -- raise error as FK does not relate to PK in ben_pl_typ_f

284: if c1%notfound then
285: --
286: close c1;
287: --
288: -- raise error as FK does not relate to PK in ben_pl_typ_f
289: -- table.
290: --
291: ben_cqb_shd.constraint_error('BEN_CBR_QUALD_BNF_DT4');
292: --