APPS.BEN_ELIG_CVRD_DPNT_API dependencies on BEN_OPT_F

Line 2706: l_opt_name ben_opt_f.name%type; -- UTF8 Change Bug 2254683

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
2710: --

Line 2891: ben_opt_f o,

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
2895: and p.pl_id=en.pl_id