APPS.BEN_PERSON_DELETE dependencies on BEN_BATCH_RANGES

Line 2160: FROM ben_batch_ranges

2156: CURSOR c4 (
2157: p_benefit_action_id NUMBER
2158: ) IS
2159: SELECT range_id
2160: FROM ben_batch_ranges
2161: WHERE benefit_action_id = p_benefit_action_id
2162: FOR UPDATE OF range_id;
2163:
2164: --

Line 2194: <>

2190: CLOSE c3;
2191: OPEN c4 (
2192: r1.benefit_action_id
2193: );
2194: <>
2195: LOOP
2196: FETCH c4 INTO l_id;
2197: EXIT WHEN c4%NOTFOUND;
2198: DELETE FROM ben_batch_ranges

Line 2198: DELETE FROM ben_batch_ranges

2194: <>
2195: LOOP
2196: FETCH c4 INTO l_id;
2197: EXIT WHEN c4%NOTFOUND;
2198: DELETE FROM ben_batch_ranges
2199: WHERE CURRENT OF c4;
2200: END LOOP ben_batch_ranges;
2201: CLOSE c4;
2202: END LOOP;

Line 2200: END LOOP ben_batch_ranges;

2196: FETCH c4 INTO l_id;
2197: EXIT WHEN c4%NOTFOUND;
2198: DELETE FROM ben_batch_ranges
2199: WHERE CURRENT OF c4;
2200: END LOOP ben_batch_ranges;
2201: CLOSE c4;
2202: END LOOP;
2203: hr_utility.set_location('Leaving: '||l_proc,999);
2204: END delete_benefit_action_children;