APPS.BEN_PERSON_DELETE dependencies on BEN_BATCH_ACTN_ITEM_INFO

Line 11: FROM ben_batch_actn_item_info

7: CURSOR c1 (
8: p_person_id NUMBER
9: ) IS
10: SELECT 1
11: FROM ben_batch_actn_item_info
12: WHERE person_id = p_person_id;
13: CURSOR c2 (
14: p_person_id NUMBER
15: ) IS

Line 227: -- Testing for values in BEN_BATCH_ACTN_ITEM_INFO

223: l_temp VARCHAR2 (2);
224: BEGIN
225:
226: --
227: -- Testing for values in BEN_BATCH_ACTN_ITEM_INFO
228: --
229: OPEN c1 (
230: p_person_id
231: );

Line 243: 'BEN_BATCH_ACTN_ITEM_INFO'

239: 'BEN_94121_DT_CHILD_EXISTS'
240: );
241: fnd_message.set_token (
242: 'TABLE_NAME',
243: 'BEN_BATCH_ACTN_ITEM_INFO'
244: );
245: fnd_message.raise_error;
246: END IF;
247:

Line 2282: FROM ben_batch_actn_item_info

2278: CURSOR c20 (
2279: p_person_id NUMBER
2280: ) IS
2281: SELECT batch_actn_item_id
2282: FROM ben_batch_actn_item_info
2283: WHERE person_id = p_person_id
2284: FOR UPDATE OF batch_actn_item_id;
2285:
2286: --

Line 2613: <>

2609: --
2610: OPEN c20 (
2611: p_person_id
2612: );
2613: <>
2614: LOOP
2615: FETCH c20 INTO l_id;
2616: EXIT WHEN c20%NOTFOUND;
2617: DELETE FROM ben_batch_actn_item_info

Line 2617: DELETE FROM ben_batch_actn_item_info

2613: <>
2614: LOOP
2615: FETCH c20 INTO l_id;
2616: EXIT WHEN c20%NOTFOUND;
2617: DELETE FROM ben_batch_actn_item_info
2618: WHERE CURRENT OF c20;
2619: END LOOP ben_batch_actn_item_info;
2620: CLOSE c20;
2621: --

Line 2619: END LOOP ben_batch_actn_item_info;

2615: FETCH c20 INTO l_id;
2616: EXIT WHEN c20%NOTFOUND;
2617: DELETE FROM ben_batch_actn_item_info
2618: WHERE CURRENT OF c20;
2619: END LOOP ben_batch_actn_item_info;
2620: CLOSE c20;
2621: --
2622: OPEN c21 (
2623: p_person_id