APPS.BEN_DM_DELETE dependencies on BEN_PRTT_ENRT_ACTN_F

Line 201: delete from ben_prtt_enrt_actn_f where prtt_enrt_rslt_id in

197:
198: delete from ben_bnft_prvdd_ldgr_f where prtt_enrt_rslt_id in
199: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);
200:
201: delete from ben_prtt_enrt_actn_f where prtt_enrt_rslt_id in
202: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);
203:
204: delete from ben_prtt_enrt_actn_f where elig_cvrd_dpnt_id in
205: (select elig_cvrd_dpnt_id from ben_elig_cvrd_dpnt_f where prtt_enrt_rslt_id in

Line 204: delete from ben_prtt_enrt_actn_f where elig_cvrd_dpnt_id in

200:
201: delete from ben_prtt_enrt_actn_f where prtt_enrt_rslt_id in
202: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);
203:
204: delete from ben_prtt_enrt_actn_f where elig_cvrd_dpnt_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

Line 208: delete from ben_prtt_enrt_actn_f where pl_bnf_id in

204: delete from ben_prtt_enrt_actn_f where elig_cvrd_dpnt_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