eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PPL_BUS dependencies on BEN_ENRT_PERD

Line 315: -- check if csd_by_ptnl_ler_for_per_id value exists in ben_enrt_perd table

311: and nvl(p_csd_by_ptnl_ler_for_per_id,hr_api.g_number)
312: <> nvl(ben_ppl_shd.g_old_rec.csd_by_ptnl_ler_for_per_id,hr_api.g_number)
313: or (not l_api_updating and p_csd_by_ptnl_ler_for_per_id is not null )) then
314: --
315: -- check if csd_by_ptnl_ler_for_per_id value exists in ben_enrt_perd table
316: --
317: open c1;
318: --
319: fetch c1 into l_dummy;

Line 324: -- raise error as FK does not relate to PK in ben_enrt_perd

320: if c1%notfound then
321: --
322: close c1;
323: --
324: -- raise error as FK does not relate to PK in ben_enrt_perd
325: -- table.
326: --
327: ben_ppl_shd.constraint_error('BEN_PTNL_LER_FOR_PER_FK2');
328: --

Line 375: from ben_enrt_perd a

371: l_dummy varchar2(1);
372: --
373: cursor c1 is
374: select null
375: from ben_enrt_perd a
376: where a.enrt_perd_id = p_enrt_perd_id;
377: --
378: Begin
379: --

Line 391: -- check if enrt_perd_id value exists in ben_enrt_perd table

387: and nvl(p_enrt_perd_id,hr_api.g_number)
388: <> nvl(ben_ppl_shd.g_old_rec.enrt_perd_id,hr_api.g_number)
389: or (not l_api_updating and p_enrt_perd_id is not null )) then
390: --
391: -- check if enrt_perd_id value exists in ben_enrt_perd table
392: --
393: open c1;
394: --
395: fetch c1 into l_dummy;

Line 400: -- raise error as FK does not relate to PK in ben_enrt_perd

396: if c1%notfound then
397: --
398: close c1;
399: --
400: -- raise error as FK does not relate to PK in ben_enrt_perd
401: -- table.
402: --
403: ben_ppl_shd.constraint_error('BEN_PTNL_LER_FOR_PER_FK1');
404: --