2308: where cop.oipl_id = p_oipl_id;
2309: --
2310: cursor c_epe is
2311: select null
2312: from ben_elig_per_elctbl_chc epe
2313: where epe.oipl_id = p_oipl_id;
2314: --
2315: Begin
2316: hr_utility.set_location('Entering:'||l_proc, 5);
2376: Raise l_rows_exist;
2377: End If;
2378:
2379: If p_datetrack_mode = 'ZAP' then
2380: -- Check in Ben_elig_per_elctbl_chc added rbingi, Bug 4558201
2381: Open c_epe;
2382: Fetch c_epe into l_Dummy;
2383: --
2384: If c_epe%FOUND then
2381: Open c_epe;
2382: Fetch c_epe into l_Dummy;
2383: --
2384: If c_epe%FOUND then
2385: l_table_name := 'ben_elig_per_elctbl_chc';
2386: Close c_epe ;
2387: Raise l_rows_exist ;
2388: End if;
2389: Close c_epe ;