APPS.BEN_PERSON_DELETE dependencies on BEN_BATCH_BNFT_CERT_INFO

Line 17: FROM ben_batch_bnft_cert_info

13: CURSOR c2 (
14: p_person_id NUMBER
15: ) IS
16: SELECT 1
17: FROM ben_batch_bnft_cert_info
18: WHERE person_id = p_person_id;
19: CURSOR c20 (
20: p_person_id NUMBER
21: ) IS

Line 252: -- Testing for values in BEN_BATCH_BNFT_CERT_INFO

248: --
249: CLOSE c1;
250:
251: --
252: -- Testing for values in BEN_BATCH_BNFT_CERT_INFO
253: --
254: OPEN c2 (
255: p_person_id
256: );

Line 268: 'BEN_BATCH_BNFT_CERT_INFO'

264: 'BEN_94121_DT_CHILD_EXISTS'
265: );
266: fnd_message.set_token (
267: 'TABLE_NAME',
268: 'BEN_BATCH_BNFT_CERT_INFO'
269: );
270: fnd_message.raise_error;
271: END IF;
272:

Line 2291: FROM ben_batch_bnft_cert_info

2287: CURSOR c21 (
2288: p_person_id NUMBER
2289: ) IS
2290: SELECT batch_benft_cert_id
2291: FROM ben_batch_bnft_cert_info
2292: WHERE person_id = p_person_id
2293: FOR UPDATE OF batch_benft_cert_id;
2294:
2295: --

Line 2625: <>

2621: --
2622: OPEN c21 (
2623: p_person_id
2624: );
2625: <>
2626: LOOP
2627: FETCH c21 INTO l_id;
2628: EXIT WHEN c21%NOTFOUND;
2629: DELETE FROM ben_batch_bnft_cert_info

Line 2629: DELETE FROM ben_batch_bnft_cert_info

2625: <>
2626: LOOP
2627: FETCH c21 INTO l_id;
2628: EXIT WHEN c21%NOTFOUND;
2629: DELETE FROM ben_batch_bnft_cert_info
2630: WHERE CURRENT OF c21;
2631: END LOOP ben_batch_bnft_cert_info;
2632: CLOSE c21;
2633: --

Line 2631: END LOOP ben_batch_bnft_cert_info;

2627: FETCH c21 INTO l_id;
2628: EXIT WHEN c21%NOTFOUND;
2629: DELETE FROM ben_batch_bnft_cert_info
2630: WHERE CURRENT OF c21;
2631: END LOOP ben_batch_bnft_cert_info;
2632: CLOSE c21;
2633: --
2634: OPEN c22 (
2635: p_person_id