APPS.BEN_PUMP_GET dependencies on BEN_OPT_F

Line 237: from ben_opt_f opt

233: l_opt_id := p_option_num ;
234: ELSIF p_option IS NOT NULL and p_option <> HR_API_G_VARCHAR2 THEN --BUG 6148609
235: select opt.opt_id
236: into l_opt_id
237: from ben_opt_f opt
238: where opt.name = p_option
239: and opt.business_group_id + 0 = p_business_group_id
240: and p_effective_date between
241: opt.effective_start_date and opt.effective_end_date;

Line 266: from ben_opt_f opt

262: l_opt_id := p_ended_option_num ;
263: ELSIF p_ended_option IS NOT NULL THEN
264: select opt.opt_id
265: into l_opt_id
266: from ben_opt_f opt
267: where opt.name = p_ended_option
268: and opt.business_group_id + 0 = p_business_group_id
269: and p_effective_date between
270: opt.effective_start_date and opt.effective_end_date;