APPS.BEN_EHC_BUS dependencies on BEN_OIPL_F

Line 205: from ben_oipl_f oipl

201: l_dummy varchar2(1);
202: --
203: cursor c1 is
204: select null
205: from ben_oipl_f oipl
206: where oipl.oipl_id = p_oipl_id
207: and oipl.business_group_id = p_business_group_id
208: and p_effective_date
209: between oipl.effective_start_date and oipl.effective_end_date;

Line 231: -- ben_oipl_f table

227: or not l_api_updating)
228: and p_oipl_id is not null then
229: --
230: -- check if oipl_id value exists in
231: -- ben_oipl_f table
232: --
233: open c1;
234: --
235: fetch c1 into l_dummy;

Line 241: -- ben_oipl_f table.

237: --
238: close c1;
239: --
240: -- raise error as FK does not relate to PK in
241: -- ben_oipl_f table.
242: --
243: ben_ehc_shd.constraint_error('BEN_ELIG_HLTH_CVG_PRTE_F_FK2');
244: --
245: end if;