APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_OPT_F

Line 1473: from ben_opt_f opt

1469: );
1470:
1471: cursor c7 is
1472: select count(opt.opt_id)
1473: from ben_opt_f opt
1474: where opt.component_reason is not null
1475: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1476: opt.effective_start_date and opt.effective_end_date
1477: and opt.opt_id in

Line 8363: l_opt_rec ben_opt_f%rowtype;

8359: l_comp_object_name varchar2(80);
8360: l_pgm_rec ben_pgm_f%rowtype;
8361: l_pl_rec ben_pl_f%rowtype;
8362: l_oipl_rec ben_oipl_f%rowtype;
8363: l_opt_rec ben_opt_f%rowtype;
8364: l_plip_rec ben_plip_f%rowtype;
8365: l_ptip_rec ben_ptip_f%rowtype;
8366: --
8367: begin