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_YRP_BUS dependencies on BEN_YR_PERD

Line 56: ben_yrp_shd.constraint_error('BEN_YR_PERDS_PK');

52: <> ben_yrp_shd.g_old_rec.yr_perd_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_yrp_shd.constraint_error('BEN_YR_PERDS_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ben_yrp_shd.constraint_error('BEN_YR_PERDS_PK');

62: if p_yr_perd_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_yrp_shd.constraint_error('BEN_YR_PERDS_PK');
67: --
68: end if;
69: --
70: end if;

Line 251: from ben_yr_perd

247: is
248: l_proc varchar2(72) := g_package||'chk_start_and_end_dt_unique';
249: l_dummy char(1);
250: cursor c1 is select null
251: from ben_yr_perd
252: Where yr_perd_id <> nvl(p_yr_perd_id,-1)
253: and start_date = p_start_date
254: and end_date = p_end_date
255: and business_group_id = p_business_group_id;

Line 628: ben_yr_perd b

624: --
625: cursor csr_leg_code is
626: select a.legislation_code
627: from per_business_groups a,
628: ben_yr_perd b
629: where b.yr_perd_id = p_yr_perd_id
630: and a.business_group_id = b.business_group_id;
631: --
632: -- Declare local variables