APPS.BEN_PEN_BUS dependencies on BEN_OPT_F

Line 2903: ben_opt_f opt

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

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

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