APPS.BEN_ENP_BUS dependencies on BEN_YR_PERD

Line 195: from ben_yr_perd a

191:
192: --
193: cursor c1 is
194: select null
195: from ben_yr_perd a
196: where a.yr_perd_id = p_yr_perd_id;
197: --
198: /*
199: cursor chk_unique is

Line 223: -- check if yr_perd_id value exists in ben_yr_perd table

219: and nvl(p_yr_perd_id,hr_api.g_number)
220: <> nvl(ben_enp_shd.g_old_rec.yr_perd_id,hr_api.g_number)
221: or not l_api_updating) then
222: --
223: -- check if yr_perd_id value exists in ben_yr_perd table
224: --
225: open c1;
226: --
227: fetch c1 into l_dummy;

Line 232: -- raise error as FK does not relate to PK in ben_yr_perd

228: if c1%notfound then
229: --
230: close c1;
231: --
232: -- raise error as FK does not relate to PK in ben_yr_perd
233: -- table.
234: --
235: ben_enp_shd.constraint_error('BEN_ENRT_PERD_FK1');
236: --