APPS.BEN_CEP_BUS dependencies on BEN_PL_F

Line 348: from ben_prtn_elig_f prtn, ben_pl_f p

344: l_exists varchar2(1);
345: --
346: cursor c1 is
347: select null
348: from ben_prtn_elig_f prtn, ben_pl_f p
349: where prtn.prtn_elig_id = p_prtn_elig_id
350: and prtn.pl_id = p.pl_id
351: and (p.invk_flx_cr_pl_flag = 'Y'
352: or

Line 361: from ben_prtn_elig_f epa, ben_pl_f pln, ben_plip_f plip

357: and p.effective_end_date;
358: --
359: cursor c2 is
360: select null
361: from ben_prtn_elig_f epa, ben_pl_f pln, ben_plip_f plip
362: where epa.prtn_elig_id = p_prtn_elig_id
363: and epa.plip_id = plip.plip_id
364: and plip.pl_id = pln.pl_id
365: and (pln.invk_flx_cr_pl_flag = 'Y'