APPS.BEN_EXT_CHLG dependencies on BEN_OPT_F

Line 3847: l_new_option_name ben_opt_f.name%type;

3843: l_proc varchar2(72) := 'ben_ext_chlg.log_benefit_chg';
3844:
3845: l_new_plan_name ben_pl_f.name%type;
3846: l_old_plan_name ben_pl_f.name%type;
3847: l_new_option_name ben_opt_f.name%type;
3848: l_old_option_name ben_opt_f.name%type;
3849: --
3850: l_ext_chg_evt_log_id number;
3851: l_object_version_number number;

Line 3848: l_old_option_name ben_opt_f.name%type;

3844:
3845: l_new_plan_name ben_pl_f.name%type;
3846: l_old_plan_name ben_pl_f.name%type;
3847: l_new_option_name ben_opt_f.name%type;
3848: l_old_option_name ben_opt_f.name%type;
3849: --
3850: l_ext_chg_evt_log_id number;
3851: l_object_version_number number;
3852: --

Line 3865: ben_opt_f opt

3861: cursor c_option_name(p_oipl_id number)
3862: is
3863: select opt.name
3864: from ben_oipl_f cop,
3865: ben_opt_f opt
3866: where cop.oipl_id = p_oipl_id
3867: and p_effective_date between cop.effective_start_date and cop.effective_end_date
3868: and cop.opt_id = opt.opt_id
3869: and p_effective_date between opt.effective_start_date and opt.effective_end_date;

Line 4518: l_option_name ben_opt_f.name%type;

4514: --
4515: l_proc varchar2(72) := 'ben_ext_chlg.log_dependent_chg';
4516:
4517: l_plan_name ben_pl_f.name%type;
4518: l_option_name ben_opt_f.name%type;
4519: l_dpnt_full_name per_all_people_f.full_name%type;
4520: l_relationship varchar2(200);
4521: --
4522: l_ext_chg_evt_log_id number;

Line 4536: ben_opt_f opt

4532: cursor c_option_name(p_oipl_id number)
4533: is
4534: select opt.name
4535: from ben_oipl_f cop,
4536: ben_opt_f opt
4537: where cop.oipl_id = p_oipl_id
4538: and p_effective_date between cop.effective_start_date and cop.effective_end_date
4539: and cop.opt_id = opt.opt_id
4540: and p_effective_date between opt.effective_start_date and opt.effective_end_date;