APPS.BEN_CRT_BUS dependencies on BEN_PL_TYP_F

Line 347: from ben_pl_typ_f a

343: l_dummy varchar2(1);
344: --
345: cursor c1 is
346: select null
347: from ben_pl_typ_f a
348: where a.pl_typ_id = p_pl_typ_id
349: and p_effective_date
350: between a.effective_start_date
351: and a.effective_end_date;

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

363: <> nvl(ben_crt_shd.g_old_rec.pl_typ_id,hr_api.g_number)
364: or not l_api_updating)
365: and p_pl_typ_id is not null then
366: --
367: -- check if pl_typ_id value exists in ben_pl_typ_f table
368: --
369: open c1;
370: --
371: fetch c1 into l_dummy;

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

372: if c1%notfound then
373: --
374: close c1;
375: --
376: -- raise error as FK does not relate to PK in ben_pl_typ_f
377: -- table.
378: --
379: ben_crt_shd.constraint_error('BEN_CRT_ORDR_DT3');
380: --