APPS.BEN_ELECTION_INFORMATION dependencies on BEN_PL_F

Line 856: ben_pl_f pln,

852: --
853: cursor c_comp_obj_name (p_prtt_enrt_rslt_id number) is
854: select rtrim(substr(pln.name||' '||opt.name,1,60)) -- 4203714 rtrim to chop off the trailing spaces
855: from ben_prtt_enrt_rslt_f pen,
856: ben_pl_f pln,
857: ben_oipl_f oipl,
858: ben_opt_f opt
859: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
860: and pen.pl_id = pln.pl_id

Line 1545: from ben_pl_f pln

1541: and abr.effective_end_date;
1542: --
1543: cursor c_pl_name (p_pl_id number) is
1544: select name
1545: from ben_pl_f pln
1546: where pln.pl_id = p_pl_id
1547: and l_effective_date between
1548: pln.effective_start_date and pln.effective_end_date;
1549: --

Line 8410: ben_pl_f pln,

8406: --
8407: cursor c_pl_opt_name is
8408: select pln.name || ' '|| opt.name
8409: from ben_elig_per_elctbl_chc epe,
8410: ben_pl_f pln,
8411: ben_oipl_f oipl,
8412: ben_opt_f opt
8413: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
8414: and epe.pl_id = pln.pl_id