APPS.BEN_DETERMINE_ELIGIBILITY2 dependencies on BEN_PL_F

Line 85: Remove ben_opt_f, ben_pl_f from

81: dates.
82:
83: Add c_get_elig_id columns to
84: c_prev_opt_elig_check.
85: Remove ben_opt_f, ben_pl_f from
86: c_prev_opt_elig_check. Add eff dts
87: Add proc get_start_end_dates by
88: stripping code from check_prev_elig
89: Newly elig does update, not insert.

Line 414: l_pl_rec ben_pl_f%rowtype;

410: l_prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%TYPE;
411: l_prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%TYPE;
412: l_outputs ff_exec.outputs_t;
413: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
414: l_pl_rec ben_pl_f%rowtype;
415: l_elig_pgm_rec ben_cobj_cache.g_etpr_inst_row;
416: l_elig_ptip_rec ben_cobj_cache.g_etpr_inst_row;
417: l_elig_plip_rec ben_cobj_cache.g_etpr_inst_row;
418: l_elig_pl_rec ben_cobj_cache.g_etpr_inst_row;

Line 1173: l_pl_id ben_pl_f.pl_id%type;

1169: l_effective_start_date_opt date;
1170: l_effective_end_date_opt date;
1171: l_opt_elig_flag ben_elig_per_opt_f.elig_flag%type;
1172: l_opt_id ben_opt_f.opt_id%type;
1173: l_pl_id ben_pl_f.pl_id%type;
1174: l_start_or_end varchar2(1);
1175: l_end_dt_plus_one date;
1176: l_wait_perd_cmpltn_dt date;
1177: l_wait_perd_strt_dt date;

Line 1349: from ben_ptip_f ctp,ben_pl_f pl

1345: and cpp.effective_end_date;
1346: --
1347: cursor c_get_pl_from_ptip(c_effective_date date) is
1348: select pl.pl_id
1349: from ben_ptip_f ctp,ben_pl_f pl
1350: where ctp.ptip_id = p_ptip_id
1351: and pl.pl_typ_id = ctp.pl_typ_id
1352: and c_effective_date
1353: between ctp.effective_start_date

Line 1431: l_plan_ordr_num ben_pl_f.ordr_num%type;

1427: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
1428: l_prtn_st_dt_aftr_wtg date;
1429: l_prtn_eff_strt_dt_cd varchar2(80);
1430: l_prtn_eff_strt_dt_rl number(15);
1431: l_plan_ordr_num ben_pl_f.ordr_num%type;
1432: --
1433: l_comp_rec ben_derive_part_and_rate_facts.g_cache_structure;
1434: l_oiplip_rec ben_derive_part_and_rate_facts.g_cache_structure;
1435: l_pil_rec ben_per_in_ler%rowtype;