APPS.BEN_PERSON_DELETE dependencies on BEN_BATCH_DPNT_INFO

Line 29: FROM ben_batch_dpnt_info

25: CURSOR c21 (
26: p_person_id NUMBER
27: ) IS
28: SELECT 1
29: FROM ben_batch_dpnt_info
30: WHERE person_id = p_person_id;
31: CURSOR c22 (
32: p_person_id NUMBER
33: ) IS

Line 302: -- Testing for values in BEN_BATCH_DPNT_INFO

298: --
299: CLOSE c20;
300:
301: --
302: -- Testing for values in BEN_BATCH_DPNT_INFO
303: --
304: OPEN c21 (
305: p_person_id
306: );

Line 318: 'BEN_BATCH_DPNT_INFO'

314: 'BEN_94121_DT_CHILD_EXISTS'
315: );
316: fnd_message.set_token (
317: 'TABLE_NAME',
318: 'BEN_BATCH_DPNT_INFO'
319: );
320: fnd_message.raise_error;
321: END IF;
322:

Line 2309: FROM ben_batch_dpnt_info

2305: CURSOR c23 (
2306: p_person_id NUMBER
2307: ) IS
2308: SELECT batch_dpnt_id
2309: FROM ben_batch_dpnt_info
2310: WHERE person_id = p_person_id
2311: FOR UPDATE OF batch_dpnt_id;
2312:
2313: --

Line 2649: <>

2645: --
2646: OPEN c23 (
2647: p_person_id
2648: );
2649: <>
2650: LOOP
2651: FETCH c23 INTO l_id;
2652: EXIT WHEN c23%NOTFOUND;
2653: DELETE FROM ben_batch_dpnt_info

Line 2653: DELETE FROM ben_batch_dpnt_info

2649: <>
2650: LOOP
2651: FETCH c23 INTO l_id;
2652: EXIT WHEN c23%NOTFOUND;
2653: DELETE FROM ben_batch_dpnt_info
2654: WHERE CURRENT OF c23;
2655: END LOOP ben_batch_dpnt_info;
2656: CLOSE c23;
2657: --

Line 2655: END LOOP ben_batch_dpnt_info;

2651: FETCH c23 INTO l_id;
2652: EXIT WHEN c23%NOTFOUND;
2653: DELETE FROM ben_batch_dpnt_info
2654: WHERE CURRENT OF c23;
2655: END LOOP ben_batch_dpnt_info;
2656: CLOSE c23;
2657: --
2658: OPEN c24 (
2659: p_person_id