APPS.BEN_DM_DELETE dependencies on BEN_PL_BNF_CTFN_PRVDD_F

Line 225: delete from ben_pl_bnf_ctfn_prvdd_f where pl_bnf_id in

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