APPS.BEN_EXT_CHLG dependencies on BEN_OPT_F

Line 3943: l_new_option_name ben_opt_f.name%type;

3939: l_proc varchar2(72) := 'ben_ext_chlg.log_benefit_chg';
3940:
3941: l_new_plan_name ben_pl_f.name%type;
3942: l_old_plan_name ben_pl_f.name%type;
3943: l_new_option_name ben_opt_f.name%type;
3944: l_old_option_name ben_opt_f.name%type;
3945: --
3946: l_ext_chg_evt_log_id number;
3947: l_object_version_number number;

Line 3944: l_old_option_name ben_opt_f.name%type;

3940:
3941: l_new_plan_name ben_pl_f.name%type;
3942: l_old_plan_name ben_pl_f.name%type;
3943: l_new_option_name ben_opt_f.name%type;
3944: l_old_option_name ben_opt_f.name%type;
3945: --
3946: l_ext_chg_evt_log_id number;
3947: l_object_version_number number;
3948: --

Line 3961: ben_opt_f opt

3957: cursor c_option_name(p_oipl_id number)
3958: is
3959: select opt.name
3960: from ben_oipl_f cop,
3961: ben_opt_f opt
3962: where cop.oipl_id = p_oipl_id
3963: and p_effective_date between cop.effective_start_date and cop.effective_end_date
3964: and cop.opt_id = opt.opt_id
3965: and p_effective_date between opt.effective_start_date and opt.effective_end_date;

Line 4614: l_option_name ben_opt_f.name%type;

4610: --
4611: l_proc varchar2(72) := 'ben_ext_chlg.log_dependent_chg';
4612:
4613: l_plan_name ben_pl_f.name%type;
4614: l_option_name ben_opt_f.name%type;
4615: l_dpnt_full_name per_all_people_f.full_name%type;
4616: l_relationship varchar2(200);
4617: --
4618: l_ext_chg_evt_log_id number;

Line 4632: ben_opt_f opt

4628: cursor c_option_name(p_oipl_id number)
4629: is
4630: select opt.name
4631: from ben_oipl_f cop,
4632: ben_opt_f opt
4633: where cop.oipl_id = p_oipl_id
4634: and p_effective_date between cop.effective_start_date and cop.effective_end_date
4635: and cop.opt_id = opt.opt_id
4636: and p_effective_date between opt.effective_start_date and opt.effective_end_date;