APPS.BEN_EXT_CHLG dependencies on BEN_PL_F

Line 3941: l_new_plan_name ben_pl_f.name%type;

3937: -- Local variable declarations
3938: --
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: --

Line 3942: l_old_plan_name ben_pl_f.name%type;

3938: --
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;

Line 3953: from ben_pl_f pl

3949: -- Cursor declarations.
3950: cursor c_plan_name(p_pl_id number)
3951: is
3952: select name
3953: from ben_pl_f pl
3954: where pl.pl_id = p_pl_id
3955: and p_effective_date between pl.effective_start_date and pl.effective_end_date;
3956:
3957: cursor c_option_name(p_oipl_id number)

Line 4613: l_plan_name ben_pl_f.name%type;

4609: -- Local variable declarations
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: --

Line 4624: from ben_pl_f pl

4620: --
4621: -- Cursor declarations.
4622: cursor c_plan_name(p_pl_id number) is
4623: select pl.name
4624: from ben_pl_f pl
4625: where pl.pl_id = p_pl_id
4626: and p_effective_date between pl.effective_start_date and pl.effective_end_date;
4627: --
4628: cursor c_option_name(p_oipl_id number)