APPS.BEN_PERSON_DELETE dependencies on BEN_BATCH_ELIG_INFO

Line 90: FROM ben_batch_elig_info

86: CURSOR c23 (
87: p_person_id NUMBER
88: ) IS
89: SELECT 1
90: FROM ben_batch_elig_info
91: WHERE person_id = p_person_id;
92: CURSOR c24 (
93: p_person_id NUMBER
94: ) IS

Line 401: -- Testing for values in BEN_BATCH_ELIG_INFO

397: --
398: CLOSE c22;
399:
400: --
401: -- Testing for values in BEN_BATCH_ELIG_INFO
402: --
403: OPEN c23 (
404: p_person_id
405: );

Line 417: 'BEN_BATCH_ELIG_INFO'

413: 'BEN_94121_DT_CHILD_EXISTS'
414: );
415: fnd_message.set_token (
416: 'TABLE_NAME',
417: 'BEN_BATCH_ELIG_INFO'
418: );
419: fnd_message.raise_error;
420: END IF;
421:

Line 2413: FROM ben_batch_elig_info a,ben_benefit_actions b

2409: CURSOR c25 (
2410: p_person_id NUMBER
2411: ) IS
2412: SELECT batch_elig_id
2413: FROM ben_batch_elig_info a,ben_benefit_actions b
2414: WHERE a.person_id = p_person_id
2415: and a.BENEFIT_ACTION_ID = b.BENEFIT_ACTION_ID
2416: and b.person_id = p_person_id--Bug 14505730
2417: and ( (p_per_in_ler_id is not NULL and b.MODE_CD = 'U') or (p_per_in_ler_id is NULL) )

Line 2795: <>

2791: CLOSE c24;
2792: OPEN c25 (
2793: p_person_id
2794: );
2795: <>
2796: LOOP
2797: FETCH c25 INTO l_id;
2798: EXIT WHEN c25%NOTFOUND;
2799: DELETE FROM ben_batch_elig_info

Line 2799: DELETE FROM ben_batch_elig_info

2795: <>
2796: LOOP
2797: FETCH c25 INTO l_id;
2798: EXIT WHEN c25%NOTFOUND;
2799: DELETE FROM ben_batch_elig_info
2800: WHERE CURRENT OF c25;
2801: END LOOP ben_batch_elig_info;
2802: CLOSE c25;
2803: OPEN c26 (

Line 2801: END LOOP ben_batch_elig_info;

2797: FETCH c25 INTO l_id;
2798: EXIT WHEN c25%NOTFOUND;
2799: DELETE FROM ben_batch_elig_info
2800: WHERE CURRENT OF c25;
2801: END LOOP ben_batch_elig_info;
2802: CLOSE c25;
2803: OPEN c26 (
2804: p_person_id
2805: );