APPS.BEN_DETERMINE_ELIGIBILITY2 dependencies on BEN_OPT_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 1185: l_opt_id ben_opt_f.opt_id%type;

1181: l_elig_per_oiplip_id ben_elig_per_opt_f.elig_per_opt_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;