APPS.BEN_DM_DELETE dependencies on BEN_ENRT_RT

Line 129: delete from ben_enrt_rt

125: ben_prtt_enrt_rslt_f pen
126: where pen.person_id = p_person_id
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));

Line 141: delete from ben_enrt_rt

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