APPS.BEN_PERSON_DELETE dependencies on BEN_BATCH_BNFT_CERT_INFO

Line 66: FROM ben_batch_bnft_cert_info

62: CURSOR c2 (
63: p_person_id NUMBER
64: ) IS
65: SELECT 1
66: FROM ben_batch_bnft_cert_info
67: WHERE person_id = p_person_id;
68: CURSOR c20 (
69: p_person_id NUMBER
70: ) IS

Line 301: -- Testing for values in BEN_BATCH_BNFT_CERT_INFO

297: --
298: CLOSE c1;
299:
300: --
301: -- Testing for values in BEN_BATCH_BNFT_CERT_INFO
302: --
303: OPEN c2 (
304: p_person_id
305: );

Line 317: 'BEN_BATCH_BNFT_CERT_INFO'

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

Line 2365: FROM ben_batch_bnft_cert_info a,ben_benefit_actions b

2361: CURSOR c21 (
2362: p_person_id NUMBER
2363: ) IS
2364: SELECT batch_benft_cert_id
2365: FROM ben_batch_bnft_cert_info a,ben_benefit_actions b
2366: WHERE a.person_id = p_person_id
2367: and a.BENEFIT_ACTION_ID = b.BENEFIT_ACTION_ID
2368: and b.person_id = p_person_id--Bug 14505730
2369: and ( (p_per_in_ler_id is not NULL and b.MODE_CD = 'U') or (p_per_in_ler_id is NULL) )

Line 2748: <>

2744: --
2745: OPEN c21 (
2746: p_person_id
2747: );
2748: <>
2749: LOOP
2750: FETCH c21 INTO l_id;
2751: EXIT WHEN c21%NOTFOUND;
2752: DELETE FROM ben_batch_bnft_cert_info

Line 2752: DELETE FROM ben_batch_bnft_cert_info

2748: <>
2749: LOOP
2750: FETCH c21 INTO l_id;
2751: EXIT WHEN c21%NOTFOUND;
2752: DELETE FROM ben_batch_bnft_cert_info
2753: WHERE CURRENT OF c21;
2754: END LOOP ben_batch_bnft_cert_info;
2755: CLOSE c21;
2756: --

Line 2754: END LOOP ben_batch_bnft_cert_info;

2750: FETCH c21 INTO l_id;
2751: EXIT WHEN c21%NOTFOUND;
2752: DELETE FROM ben_batch_bnft_cert_info
2753: WHERE CURRENT OF c21;
2754: END LOOP ben_batch_bnft_cert_info;
2755: CLOSE c21;
2756: --
2757: OPEN c22 (
2758: p_person_id