APPS.BEN_DM_DELETE dependencies on BEN_ELIG_CVRD_DPNT_F

Line 124: from ben_elig_cvrd_dpnt_f egd,

120:
121: delete from ben_prmry_care_prvdr_f pcp
122: where pcp.elig_cvrd_dpnt_id in
123: (select egd.elig_cvrd_dpnt_id
124: from ben_elig_cvrd_dpnt_f egd,
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:

Line 205: (select elig_cvrd_dpnt_id from ben_elig_cvrd_dpnt_f where prtt_enrt_rslt_id in

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
209: (select pl_bnf_id from ben_pl_bnf_f where prtt_enrt_rslt_id in

Line 216: (select elig_cvrd_dpnt_id from ben_elig_cvrd_dpnt_f where prtt_enrt_rslt_id in

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);
214:
215: delete from ben_cvrd_dpnt_ctfn_prvdd_f where elig_cvrd_dpnt_id in
216: (select elig_cvrd_dpnt_id from ben_elig_cvrd_dpnt_f where prtt_enrt_rslt_id in
217: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id));
218:
219: delete from ben_elig_cvrd_dpnt_f where prtt_enrt_rslt_id in
220: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);

Line 219: delete from ben_elig_cvrd_dpnt_f where prtt_enrt_rslt_id in

215: delete from ben_cvrd_dpnt_ctfn_prvdd_f where elig_cvrd_dpnt_id in
216: (select elig_cvrd_dpnt_id from ben_elig_cvrd_dpnt_f where prtt_enrt_rslt_id in
217: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id));
218:
219: delete from ben_elig_cvrd_dpnt_f where prtt_enrt_rslt_id in
220: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);
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);