APPS.BEN_PERSON_DELETE dependencies on BEN_BATCH_RANGES

Line 2226: FROM ben_batch_ranges

2222: CURSOR c4 (
2223: p_benefit_action_id NUMBER
2224: ) IS
2225: SELECT range_id
2226: FROM ben_batch_ranges
2227: WHERE benefit_action_id = p_benefit_action_id
2228: FOR UPDATE OF range_id;
2229:
2230: --

Line 2260: <>

2256: CLOSE c3;
2257: OPEN c4 (
2258: r1.benefit_action_id
2259: );
2260: <>
2261: LOOP
2262: FETCH c4 INTO l_id;
2263: EXIT WHEN c4%NOTFOUND;
2264: DELETE FROM ben_batch_ranges

Line 2264: DELETE FROM ben_batch_ranges

2260: <>
2261: LOOP
2262: FETCH c4 INTO l_id;
2263: EXIT WHEN c4%NOTFOUND;
2264: DELETE FROM ben_batch_ranges
2265: WHERE CURRENT OF c4;
2266: END LOOP ben_batch_ranges;
2267: CLOSE c4;
2268: END LOOP;

Line 2266: END LOOP ben_batch_ranges;

2262: FETCH c4 INTO l_id;
2263: EXIT WHEN c4%NOTFOUND;
2264: DELETE FROM ben_batch_ranges
2265: WHERE CURRENT OF c4;
2266: END LOOP ben_batch_ranges;
2267: CLOSE c4;
2268: END LOOP;
2269: hr_utility.set_location('Leaving: '||l_proc,999);
2270: END delete_benefit_action_children;