139: where person_id =p_person_id));
140:
141: delete from ben_enrt_rt
142: where enrt_bnft_id in
143: (select enrt_bnft_id from ben_enrt_bnft
144: where elig_per_elctbl_chc_id in
145: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
146: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
147: where person_id =p_person_id)));
153: where person_id =p_person_id));
154:
155: delete from BEN_ELCTBL_CHC_CTFN
156: where enrt_bnft_id in
157: (select enrt_bnft_id from ben_enrt_bnft
158: where elig_per_elctbl_chc_id in
159: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
160: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
161: where person_id =p_person_id)));
159: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
160: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
161: where person_id =p_person_id)));
162:
163: delete from ben_enrt_bnft
164: where elig_per_elctbl_chc_id in
165: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
166: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
167: where person_id =p_person_id));