APPS.BEN_EGD_BUS dependencies on BEN_ELIG_PER_F

Line 194: from ben_elig_per_f a

190: l_dummy varchar2(1);
191: --
192: cursor c1 is
193: select null
194: from ben_elig_per_f a
195: where a.elig_per_id = p_elig_per_id
196: and p_effective_date
197: between a.effective_start_date
198: and a.effective_end_date;

Line 214: -- check if elig_per_id value exists in ben_elig_per_f table

210: <> nvl(ben_egd_shd.g_old_rec.elig_per_id,hr_api.g_number)
211: or not l_api_updating)
212: and p_elig_per_id is not null then
213: --
214: -- check if elig_per_id value exists in ben_elig_per_f table
215: --
216: open c1;
217: --
218: fetch c1 into l_dummy;

Line 223: -- raise error as FK does not relate to PK in ben_elig_per_f

219: if c1%notfound then
220: --
221: close c1;
222: --
223: -- raise error as FK does not relate to PK in ben_elig_per_f
224: -- table.
225: --
226: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_DT2');
227: --