APPS.BEN_ELIG_CVRD_DPNT_API dependencies on BEN_PL_F

Line 2705: l_pl_name ben_pl_f.name%type; -- UTF8 Change Bug 2254683

2701: l_heir number(15);
2702: l_grp_rlshp_cd varchar2(30);
2703: l_grp_rlshp_meaning varchar2(30);
2704: ---- Added
2705: l_pl_name ben_pl_f.name%type; -- UTF8 Change Bug 2254683
2706: l_opt_name ben_opt_f.name%type; -- UTF8 Change Bug 2254683
2707: l_rel_name hr_lookups.meaning%type; -- UTF8 Change Bug 2254683
2708: --
2709: -- get required info

Line 2890: from ben_pl_f p,

2886:
2887: cursor get_pln_opt_c is
2888:
2889: select p.name pl_name, o.name opt_name
2890: from ben_pl_f p,
2891: ben_opt_f o,
2892: ben_oipl_f op,
2893: ben_prtt_enrt_rslt_f en
2894: where en.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id