APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_ELIG_PER_OPT_F

Line 2011: FROM ben_elig_per_opt_f new_epo

2007: , v_end_date IN DATE)
2008: IS
2009: SELECT new_epo.elig_per_opt_id, new_epo.object_version_number,
2010: effective_start_date, effective_end_date
2011: FROM ben_elig_per_opt_f new_epo
2012: WHERE new_epo.elig_per_id = v_elig_per_id
2013: -- bug 5658405
2014: -- AND new_epo.per_in_ler_id = p_per_in_ler_id
2015: -- AND new_epo.effective_start_date = p_effective_date

Line 2024: FROM ben_elig_per_opt_f future_epo

2020: -- added bug 5658405
2021: CURSOR get_future_epo (v_elig_per_id IN NUMBER, v_end_date IN DATE)
2022: IS
2023: SELECT future_epo.elig_per_opt_id, future_epo.object_version_number
2024: FROM ben_elig_per_opt_f future_epo
2025: WHERE elig_per_id = v_elig_per_id AND effective_end_date > v_end_date;
2026:
2027: l_effective_start_date DATE;
2028: l_effective_end_date DATE;

Line 2110: UPDATE ben_elig_per_opt_f

2106: || l_pep.end_date,
2107: 9909
2108: );
2109:
2110: UPDATE ben_elig_per_opt_f
2111: -- updating the elig_per_opt_f
2112: -- as these cant be end dated using api.
2113: SET effective_end_date = l_pep.end_date
2114: WHERE elig_per_opt_id = future_epo_rec.elig_per_opt_id