APPS.HR_PUMP_GET dependencies on BEN_OPT_F

Line 1980: from ben_opt_f opt

1976: l_opt_id number;
1977: begin
1978: select opt.opt_id
1979: into l_opt_id
1980: from ben_opt_f opt
1981: where opt.name = p_option_definition
1982: and opt.business_group_id + 0 = p_business_group_id
1983: and p_effective_date between
1984: opt.effective_start_date and opt.effective_end_date;

Line 2002: from ben_opt_f opt

1998: l_ovn number;
1999: begin
2000: select opt.object_version_number
2001: into l_ovn
2002: from ben_opt_f opt
2003: where opt.name = p_option_definition
2004: and opt.business_group_id + 0 = p_business_group_id
2005: and p_effective_date between
2006: opt.effective_start_date and opt.effective_end_date;