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 427: l_pl_rec ben_pl_f%rowtype;

423: l_prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%TYPE;
424: l_prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%TYPE;
425: l_outputs ff_exec.outputs_t;
426: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
427: l_pl_rec ben_pl_f%rowtype;
428: l_elig_pgm_rec ben_cobj_cache.g_etpr_inst_row;
429: l_elig_ptip_rec ben_cobj_cache.g_etpr_inst_row;
430: l_elig_plip_rec ben_cobj_cache.g_etpr_inst_row;
431: l_elig_pl_rec ben_cobj_cache.g_etpr_inst_row;

Line 1186: l_pl_id ben_pl_f.pl_id%type;

1182: l_effective_start_date_opt date;
1183: l_effective_end_date_opt date;
1184: l_opt_elig_flag ben_elig_per_opt_f.elig_flag%type;
1185: l_opt_id ben_opt_f.opt_id%type;
1186: l_pl_id ben_pl_f.pl_id%type;
1187: l_start_or_end varchar2(1);
1188: l_end_dt_plus_one date;
1189: l_wait_perd_cmpltn_dt date;
1190: l_wait_perd_strt_dt date;

Line 1362: from ben_ptip_f ctp,ben_pl_f pl

1358: and cpp.effective_end_date;
1359: --
1360: cursor c_get_pl_from_ptip(c_effective_date date) is
1361: select pl.pl_id
1362: from ben_ptip_f ctp,ben_pl_f pl
1363: where ctp.ptip_id = p_ptip_id
1364: and pl.pl_typ_id = ctp.pl_typ_id
1365: and c_effective_date
1366: between ctp.effective_start_date

Line 1444: l_plan_ordr_num ben_pl_f.ordr_num%type;

1440: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
1441: l_prtn_st_dt_aftr_wtg date;
1442: l_prtn_eff_strt_dt_cd varchar2(80);
1443: l_prtn_eff_strt_dt_rl number(15);
1444: l_plan_ordr_num ben_pl_f.ordr_num%type;
1445: --
1446: l_comp_rec ben_derive_part_and_rate_facts.g_cache_structure;
1447: l_oiplip_rec ben_derive_part_and_rate_facts.g_cache_structure;
1448: l_pil_rec ben_per_in_ler%rowtype;