APPS.BEN_DM_DELETE dependencies on BEN_PL_BNF_F

Line 209: (select pl_bnf_id from ben_pl_bnf_f where prtt_enrt_rslt_id in

205: (select elig_cvrd_dpnt_id from ben_elig_cvrd_dpnt_f where prtt_enrt_rslt_id in
206: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id));
207:
208: delete from ben_prtt_enrt_actn_f where pl_bnf_id in
209: (select pl_bnf_id from ben_pl_bnf_f where prtt_enrt_rslt_id in
210: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id));
211:
212: delete from ben_prtt_enrt_ctfn_prvdd_f where prtt_enrt_rslt_id in
213: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);

Line 226: (select pl_bnf_id from ben_pl_bnf_f where prtt_enrt_rslt_id in

222: delete from ben_elig_dpnt where per_in_ler_id in
223: (select per_in_ler_id from ben_per_in_ler where person_id =p_person_id);
224:
225: delete from ben_pl_bnf_ctfn_prvdd_f where pl_bnf_id in
226: (select pl_bnf_id from ben_pl_bnf_f where prtt_enrt_rslt_id in
227: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id));
228:
229: delete from ben_pl_bnf_f where prtt_enrt_rslt_id in
230: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);

Line 229: delete from ben_pl_bnf_f where prtt_enrt_rslt_id in

225: delete from ben_pl_bnf_ctfn_prvdd_f where pl_bnf_id in
226: (select pl_bnf_id from ben_pl_bnf_f where prtt_enrt_rslt_id in
227: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id));
228:
229: delete from ben_pl_bnf_f where prtt_enrt_rslt_id in
230: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);
231:
232: delete from ben_prtt_enrt_rslt_f where person_id =p_person_id;
233: