APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_OPT_F

Line 1865: from ben_opt_f opt

1861: );
1862:
1863: cursor c7 is
1864: select count(opt.opt_id)
1865: from ben_opt_f opt
1866: where opt.component_reason is not null
1867: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1868: opt.effective_start_date and opt.effective_end_date
1869: and opt.opt_id in

Line 8771: l_opt_rec ben_opt_f%rowtype;

8767: l_comp_object_name varchar2(80);
8768: l_pgm_rec ben_pgm_f%rowtype;
8769: l_pl_rec ben_pl_f%rowtype;
8770: l_oipl_rec ben_oipl_f%rowtype;
8771: l_opt_rec ben_opt_f%rowtype;
8772: l_plip_rec ben_plip_f%rowtype;
8773: l_ptip_rec ben_ptip_f%rowtype;
8774: --
8775: begin