APPS.BEN_DM_DELETE dependencies on BEN_ELCTBL_CHC_CTFN

Line 149: delete from BEN_ELCTBL_CHC_CTFN

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

Line 155: delete from BEN_ELCTBL_CHC_CTFN

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