APPS.BEN_EXT_CHLG dependencies on BEN_PL_F

Line 3845: l_new_plan_name ben_pl_f.name%type;

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

Line 3846: l_old_plan_name ben_pl_f.name%type;

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

Line 3857: from ben_pl_f pl

3853: -- Cursor declarations.
3854: cursor c_plan_name(p_pl_id number)
3855: is
3856: select name
3857: from ben_pl_f pl
3858: where pl.pl_id = p_pl_id
3859: and p_effective_date between pl.effective_start_date and pl.effective_end_date;
3860:
3861: cursor c_option_name(p_oipl_id number)

Line 4517: l_plan_name ben_pl_f.name%type;

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

Line 4528: from ben_pl_f pl

4524: --
4525: -- Cursor declarations.
4526: cursor c_plan_name(p_pl_id number) is
4527: select pl.name
4528: from ben_pl_f pl
4529: where pl.pl_id = p_pl_id
4530: and p_effective_date between pl.effective_start_date and pl.effective_end_date;
4531: --
4532: cursor c_option_name(p_oipl_id number)