2434: IS
2435: CURSOR c_get_ee_end_date
2436: IS
2437: SELECT effective_end_date
2438: FROM pay_element_entries_f
2439: WHERE element_entry_id = p_element_entry_id;
2440:
2441: l_ee_end_date pay_element_entries_f.effective_end_date%TYPE;
2442: BEGIN
2437: SELECT effective_end_date
2438: FROM pay_element_entries_f
2439: WHERE element_entry_id = p_element_entry_id;
2440:
2441: l_ee_end_date pay_element_entries_f.effective_end_date%TYPE;
2442: BEGIN
2443: OPEN c_get_ee_end_date;
2444: FETCH c_get_ee_end_date INTO l_ee_end_date;
2445: CLOSE c_get_ee_end_date;