APPS.BEN_PERSON_DELETE dependencies on BEN_BATCH_ELCTBL_CHC_INFO

Line 84: FROM ben_batch_elctbl_chc_info

80: CURSOR c22 (
81: p_person_id NUMBER
82: ) IS
83: SELECT 1
84: FROM ben_batch_elctbl_chc_info
85: WHERE person_id = p_person_id;
86: CURSOR c23 (
87: p_person_id NUMBER
88: ) IS

Line 376: -- Testing for values in BEN_BATCH_ELCTBL_CHC_INFO

372: --
373: CLOSE c21;
374:
375: --
376: -- Testing for values in BEN_BATCH_ELCTBL_CHC_INFO
377: --
378: OPEN c22 (
379: p_person_id
380: );

Line 392: 'BEN_BATCH_ELCTBL_CHC_INFO'

388: 'BEN_94121_DT_CHILD_EXISTS'
389: );
390: fnd_message.set_token (
391: 'TABLE_NAME',
392: 'BEN_BATCH_ELCTBL_CHC_INFO'
393: );
394: fnd_message.raise_error;
395: END IF;
396:

Line 2401: FROM ben_batch_elctbl_chc_info a,ben_benefit_actions b

2397: CURSOR c24 (
2398: p_person_id NUMBER
2399: ) IS
2400: SELECT batch_elctbl_id
2401: FROM ben_batch_elctbl_chc_info a,ben_benefit_actions b
2402: WHERE a.person_id = p_person_id
2403: and a.BENEFIT_ACTION_ID = b.BENEFIT_ACTION_ID
2404: and b.person_id = p_person_id--Bug 14505730
2405: and ( (p_per_in_ler_id is not NULL and b.MODE_CD = 'U') or (p_per_in_ler_id is NULL) )

Line 2784: <>

2780: --
2781: OPEN c24 (
2782: p_person_id
2783: );
2784: <>
2785: LOOP
2786: FETCH c24 INTO l_id;
2787: EXIT WHEN c24%NOTFOUND;
2788: DELETE FROM ben_batch_elctbl_chc_info

Line 2788: DELETE FROM ben_batch_elctbl_chc_info

2784: <>
2785: LOOP
2786: FETCH c24 INTO l_id;
2787: EXIT WHEN c24%NOTFOUND;
2788: DELETE FROM ben_batch_elctbl_chc_info
2789: WHERE CURRENT OF c24;
2790: END LOOP ben_batch_elctbl_chc_info;
2791: CLOSE c24;
2792: OPEN c25 (

Line 2790: END LOOP ben_batch_elctbl_chc_info;

2786: FETCH c24 INTO l_id;
2787: EXIT WHEN c24%NOTFOUND;
2788: DELETE FROM ben_batch_elctbl_chc_info
2789: WHERE CURRENT OF c24;
2790: END LOOP ben_batch_elctbl_chc_info;
2791: CLOSE c24;
2792: OPEN c25 (
2793: p_person_id
2794: );