APPS.BEN_PEN_BUS dependencies on BEN_OPT_F

Line 2902: ben_opt_f opt

2898: --Bug 2390734 Changed the join condition to compare OPT.OPT_ID with OIPL.OPT_ID.(Intially it was being compared with itself)
2899: cursor c_opt_name(cv_oipl_id in number) is
2900: select ' : ' || opt.name
2901: from ben_oipl_f oipl,
2902: ben_opt_f opt
2903: where oipl.oipl_id = cv_oipl_id
2904: and opt.opt_id = oipl.opt_id --Bug 2390734
2905: and opt.business_group_id = p_business_group_id
2906: and oipl.business_group_id = p_business_group_id;

Line 2944: l_option_name ben_opt_f.name%type; -- UTF8 Change Bug 2254683

2940: -- Bug 2162121
2941: --
2942: l_ptip_tbl_ct number := g_ptip_tbl.count;
2943: l_plan_name ben_pl_f.name%type; -- UTF8 Change Bug 2254683
2944: l_option_name ben_opt_f.name%type; -- UTF8 Change Bug 2254683
2945: --
2946: l_pl_rec ben_cobj_cache.g_pl_inst_row;
2947: /*
2948: l_pl_rec ben_pl_f%rowtype;