APPS.BEN_PERSON_DELETE dependencies on BEN_BATCH_ELCTBL_CHC_INFO

Line 35: FROM ben_batch_elctbl_chc_info

31: CURSOR c22 (
32: p_person_id NUMBER
33: ) IS
34: SELECT 1
35: FROM ben_batch_elctbl_chc_info
36: WHERE person_id = p_person_id;
37: CURSOR c23 (
38: p_person_id NUMBER
39: ) IS

Line 327: -- Testing for values in BEN_BATCH_ELCTBL_CHC_INFO

323: --
324: CLOSE c21;
325:
326: --
327: -- Testing for values in BEN_BATCH_ELCTBL_CHC_INFO
328: --
329: OPEN c22 (
330: p_person_id
331: );

Line 343: 'BEN_BATCH_ELCTBL_CHC_INFO'

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

Line 2318: FROM ben_batch_elctbl_chc_info

2314: CURSOR c24 (
2315: p_person_id NUMBER
2316: ) IS
2317: SELECT batch_elctbl_id
2318: FROM ben_batch_elctbl_chc_info
2319: WHERE person_id = p_person_id
2320: FOR UPDATE OF batch_elctbl_id;
2321:
2322: --

Line 2661: <>

2657: --
2658: OPEN c24 (
2659: p_person_id
2660: );
2661: <>
2662: LOOP
2663: FETCH c24 INTO l_id;
2664: EXIT WHEN c24%NOTFOUND;
2665: DELETE FROM ben_batch_elctbl_chc_info

Line 2665: DELETE FROM ben_batch_elctbl_chc_info

2661: <>
2662: LOOP
2663: FETCH c24 INTO l_id;
2664: EXIT WHEN c24%NOTFOUND;
2665: DELETE FROM ben_batch_elctbl_chc_info
2666: WHERE CURRENT OF c24;
2667: END LOOP ben_batch_elctbl_chc_info;
2668: CLOSE c24;
2669: OPEN c25 (

Line 2667: END LOOP ben_batch_elctbl_chc_info;

2663: FETCH c24 INTO l_id;
2664: EXIT WHEN c24%NOTFOUND;
2665: DELETE FROM ben_batch_elctbl_chc_info
2666: WHERE CURRENT OF c24;
2667: END LOOP ben_batch_elctbl_chc_info;
2668: CLOSE c24;
2669: OPEN c25 (
2670: p_person_id
2671: );