127: and egd.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id);
128:
129: delete from ben_enrt_rt
130: where elig_per_elctbl_chc_id in
131: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
132: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
133: where person_id =p_person_id));
134:
135: delete from ben_enrt_prem
133: where person_id =p_person_id));
134:
135: delete from ben_enrt_prem
136: where elig_per_elctbl_chc_id in
137: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
138: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
139: where person_id =p_person_id));
140:
141: delete from ben_enrt_rt
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)));
148:
149: delete from BEN_ELCTBL_CHC_CTFN
147: where person_id =p_person_id)));
148:
149: delete from BEN_ELCTBL_CHC_CTFN
150: where elig_per_elctbl_chc_id in
151: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
152: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
153: where person_id =p_person_id));
154:
155: delete from BEN_ELCTBL_CHC_CTFN
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)));
162:
163: delete from ben_enrt_bnft
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));
168:
169: delete from ben_elig_per_elctbl_chc
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));
168:
169: delete from ben_elig_per_elctbl_chc
170: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
171: where person_id =p_person_id);
172:
173: delete from ben_pil_elctbl_chc_popl