APPS.BEN_CER_BUS dependencies on BEN_PL_F

Line 412: from ben_prtn_elig_f prtn, ben_pl_f p

408: l_exists varchar2(1);
409: --
410: cursor c1 is
411: select null
412: from ben_prtn_elig_f prtn, ben_pl_f p
413: where prtn.prtn_elig_id = p_prtn_elig_id
414: and prtn.pl_id = p.pl_id
415: and (p.invk_flx_cr_pl_flag = 'Y'
416: or

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

421: and p.effective_end_date;
422: --
423: cursor c2 is
424: select null
425: from ben_prtn_elig_f epa, ben_pl_f pln, ben_plip_f plip
426: where epa.prtn_elig_id = p_prtn_elig_id
427: and epa.plip_id = plip.plip_id
428: and plip.pl_id = pln.pl_id
429: and (pln.invk_flx_cr_pl_flag = 'Y'