APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_ELIG_PER_OPT_F

Line 2014: FROM ben_elig_per_opt_f new_epo

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

Line 2027: FROM ben_elig_per_opt_f future_epo

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

Line 2113: UPDATE ben_elig_per_opt_f

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