APPS.BEN_EGD_BUS dependencies on BEN_PER_IN_LER

Line 354: from ben_per_in_ler a ,

350: l_dummy varchar2(1);
351: --
352: cursor c1 is
353: select null
354: from ben_per_in_ler a ,
355: ben_ler_f b
356: where a.per_in_ler_id = p_per_in_ler_id
357: and a.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
358: and a.ler_id = b.ler_id

Line 378: -- check if per_in_ler_id value exists in ben_per_in_ler table

374: <> nvl(ben_egd_shd.g_old_rec.per_in_ler_id,hr_api.g_number)
375: or not l_api_updating) and
376: p_per_in_ler_id is not null then
377: --
378: -- check if per_in_ler_id value exists in ben_per_in_ler table
379: --
380: open c1;
381: --
382: fetch c1 into l_dummy;

Line 387: -- raise error as FK does not relate to PK in ben_per_in_ler

383: if c1%notfound then
384: --
385: close c1;
386: --
387: -- raise error as FK does not relate to PK in ben_per_in_ler
388: -- table.
389: --
390: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_FK2');
391: --