APPS.BEN_ICD_PLAN_DESIGN_SETUP dependencies on BEN_OPT_F

Line 47: from ben_opt_f opt

43: l_element c_element%rowtype;
44:
45: cursor c_opt(v_name varchar2) is
46: select opt.opt_id
47: from ben_opt_f opt
48: where opt.business_group_id = p_business_group_id
49: and p_effective_date between
50: opt.effective_start_date and opt.effective_end_date
51: and opt.name = v_name;

Line 368: from ben_opt_f opt

364: and pln.pl_typ_id = v_pl_typ_id);
365:
366: cursor c_opt(v_opt_id number) is
367: select opt.object_version_number
368: from ben_opt_f opt
369: where opt.opt_id = v_opt_id
370: and p_effective_date between
371: opt.effective_start_date and opt.effective_end_date
372: and not exists