APPS.BEN_PERSON_DELETE dependencies on BEN_BATCH_LER_INFO

Line 96: FROM ben_batch_ler_info

92: CURSOR c24 (
93: p_person_id NUMBER
94: ) IS
95: SELECT 1
96: FROM ben_batch_ler_info
97: WHERE person_id = p_person_id;
98: CURSOR c25 (
99: p_person_id NUMBER
100: ) IS

Line 426: -- Testing for values in BEN_BATCH_LER_INFO

422: --
423: CLOSE c23;
424:
425: --
426: -- Testing for values in BEN_BATCH_LER_INFO
427: --
428: OPEN c24 (
429: p_person_id
430: );

Line 442: 'BEN_BATCH_LER_INFO'

438: 'BEN_94121_DT_CHILD_EXISTS'
439: );
440: fnd_message.set_token (
441: 'TABLE_NAME',
442: 'BEN_BATCH_LER_INFO'
443: );
444: fnd_message.raise_error;
445: END IF;
446:

Line 2425: FROM ben_batch_ler_info a,ben_benefit_actions b

2421: CURSOR c26 (
2422: p_person_id NUMBER
2423: ) IS
2424: SELECT batch_ler_id
2425: FROM ben_batch_ler_info a,ben_benefit_actions b
2426: WHERE a.person_id = p_person_id
2427: and a.BENEFIT_ACTION_ID = b.BENEFIT_ACTION_ID
2428: and b.person_id = p_person_id--Bug 14505730
2429: and ( (p_per_in_ler_id is not NULL and b.MODE_CD = 'U') or (p_per_in_ler_id is NULL) )

Line 2806: <>

2802: CLOSE c25;
2803: OPEN c26 (
2804: p_person_id
2805: );
2806: <>
2807: LOOP
2808: FETCH c26 INTO l_id;
2809: EXIT WHEN c26%NOTFOUND;
2810: DELETE FROM ben_batch_ler_info

Line 2810: DELETE FROM ben_batch_ler_info

2806: <>
2807: LOOP
2808: FETCH c26 INTO l_id;
2809: EXIT WHEN c26%NOTFOUND;
2810: DELETE FROM ben_batch_ler_info
2811: WHERE CURRENT OF c26;
2812: END LOOP ben_batch_ler_info;
2813: CLOSE c26;
2814: OPEN c27 (

Line 2812: END LOOP ben_batch_ler_info;

2808: FETCH c26 INTO l_id;
2809: EXIT WHEN c26%NOTFOUND;
2810: DELETE FROM ben_batch_ler_info
2811: WHERE CURRENT OF c26;
2812: END LOOP ben_batch_ler_info;
2813: CLOSE c26;
2814: OPEN c27 (
2815: p_person_id
2816: );