APPS.BEN_ELECTION_INFORMATION dependencies on BEN_PL_F

Line 771: ben_pl_f pln,

767: --
768: cursor c_comp_obj_name (p_prtt_enrt_rslt_id number) is
769: select rtrim(substr(pln.name||' '||opt.name,1,60)) -- 4203714 rtrim to chop off the trailing spaces
770: from ben_prtt_enrt_rslt_f pen,
771: ben_pl_f pln,
772: ben_oipl_f oipl,
773: ben_opt_f opt
774: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
775: and pen.pl_id = pln.pl_id

Line 1336: from ben_pl_f pln

1332: and abr.effective_end_date;
1333: --
1334: cursor c_pl_name (p_pl_id number) is
1335: select name
1336: from ben_pl_f pln
1337: where pln.pl_id = p_pl_id
1338: and l_effective_date between
1339: pln.effective_start_date and pln.effective_end_date;
1340: --

Line 7285: ben_pl_f pln,

7281: --
7282: cursor c_pl_opt_name is
7283: select pln.name || ' '|| opt.name
7284: from ben_elig_per_elctbl_chc epe,
7285: ben_pl_f pln,
7286: ben_oipl_f oipl,
7287: ben_opt_f opt
7288: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
7289: and epe.pl_id = pln.pl_id