APPS.BEN_PERSON_DELETE dependencies on BEN_BATCH_DPNT_INFO

Line 78: FROM ben_batch_dpnt_info

74: CURSOR c21 (
75: p_person_id NUMBER
76: ) IS
77: SELECT 1
78: FROM ben_batch_dpnt_info
79: WHERE person_id = p_person_id;
80: CURSOR c22 (
81: p_person_id NUMBER
82: ) IS

Line 351: -- Testing for values in BEN_BATCH_DPNT_INFO

347: --
348: CLOSE c20;
349:
350: --
351: -- Testing for values in BEN_BATCH_DPNT_INFO
352: --
353: OPEN c21 (
354: p_person_id
355: );

Line 367: 'BEN_BATCH_DPNT_INFO'

363: 'BEN_94121_DT_CHILD_EXISTS'
364: );
365: fnd_message.set_token (
366: 'TABLE_NAME',
367: 'BEN_BATCH_DPNT_INFO'
368: );
369: fnd_message.raise_error;
370: END IF;
371:

Line 2389: FROM ben_batch_dpnt_info a,ben_benefit_actions b

2385: CURSOR c23 (
2386: p_person_id NUMBER
2387: ) IS
2388: SELECT batch_dpnt_id
2389: FROM ben_batch_dpnt_info a,ben_benefit_actions b
2390: WHERE a.person_id = p_person_id
2391: and a.BENEFIT_ACTION_ID = b.BENEFIT_ACTION_ID
2392: and b.person_id = p_person_id--Bug 14505730
2393: and ( (p_per_in_ler_id is not NULL and b.MODE_CD = 'U') or (p_per_in_ler_id is NULL) )

Line 2772: <>

2768: --
2769: OPEN c23 (
2770: p_person_id
2771: );
2772: <>
2773: LOOP
2774: FETCH c23 INTO l_id;
2775: EXIT WHEN c23%NOTFOUND;
2776: DELETE FROM ben_batch_dpnt_info

Line 2776: DELETE FROM ben_batch_dpnt_info

2772: <>
2773: LOOP
2774: FETCH c23 INTO l_id;
2775: EXIT WHEN c23%NOTFOUND;
2776: DELETE FROM ben_batch_dpnt_info
2777: WHERE CURRENT OF c23;
2778: END LOOP ben_batch_dpnt_info;
2779: CLOSE c23;
2780: --

Line 2778: END LOOP ben_batch_dpnt_info;

2774: FETCH c23 INTO l_id;
2775: EXIT WHEN c23%NOTFOUND;
2776: DELETE FROM ben_batch_dpnt_info
2777: WHERE CURRENT OF c23;
2778: END LOOP ben_batch_dpnt_info;
2779: CLOSE c23;
2780: --
2781: OPEN c24 (
2782: p_person_id