APPS.BEN_PERSON_DELETE dependencies on BEN_BATCH_COMMU_INFO

Line 72: FROM ben_batch_commu_info

68: CURSOR c20 (
69: p_person_id NUMBER
70: ) IS
71: SELECT 1
72: FROM ben_batch_commu_info
73: WHERE person_id = p_person_id;
74: CURSOR c21 (
75: p_person_id NUMBER
76: ) IS

Line 326: -- Testing for values in BEN_BATCH_COMMU_INFO

322: --
323: CLOSE c2;
324:
325: --
326: -- Testing for values in BEN_BATCH_COMMU_INFO
327: --
328: OPEN c20 (
329: p_person_id
330: );

Line 342: 'BEN_BATCH_COMMU_INFO'

338: 'BEN_94121_DT_CHILD_EXISTS'
339: );
340: fnd_message.set_token (
341: 'TABLE_NAME',
342: 'BEN_BATCH_COMMU_INFO'
343: );
344: fnd_message.raise_error;
345: END IF;
346:

Line 2377: FROM ben_batch_commu_info a,ben_benefit_actions b

2373: CURSOR c22 (
2374: p_person_id NUMBER
2375: ) IS
2376: SELECT batch_commu_id
2377: FROM ben_batch_commu_info a,ben_benefit_actions b
2378: WHERE a.person_id = p_person_id
2379: and a.BENEFIT_ACTION_ID = b.BENEFIT_ACTION_ID
2380: and b.person_id = p_person_id--Bug 14505730
2381: and ( (p_per_in_ler_id is not NULL and b.MODE_CD = 'U') or (p_per_in_ler_id is NULL) )

Line 2760: <>

2756: --
2757: OPEN c22 (
2758: p_person_id
2759: );
2760: <>
2761: LOOP
2762: FETCH c22 INTO l_id;
2763: EXIT WHEN c22%NOTFOUND;
2764: DELETE FROM ben_batch_commu_info

Line 2764: DELETE FROM ben_batch_commu_info

2760: <>
2761: LOOP
2762: FETCH c22 INTO l_id;
2763: EXIT WHEN c22%NOTFOUND;
2764: DELETE FROM ben_batch_commu_info
2765: WHERE CURRENT OF c22;
2766: END LOOP ben_batch_commu_info;
2767: CLOSE c22;
2768: --

Line 2766: END LOOP ben_batch_commu_info;

2762: FETCH c22 INTO l_id;
2763: EXIT WHEN c22%NOTFOUND;
2764: DELETE FROM ben_batch_commu_info
2765: WHERE CURRENT OF c22;
2766: END LOOP ben_batch_commu_info;
2767: CLOSE c22;
2768: --
2769: OPEN c23 (
2770: p_person_id