APPS.BEN_DM_DELETE dependencies on BEN_ENRT_BNFT

Line 143: (select enrt_bnft_id from ben_enrt_bnft

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)));

Line 157: (select enrt_bnft_id from ben_enrt_bnft

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)));

Line 163: delete from ben_enrt_bnft

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));