eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DM_DELETE dependencies on BEN_PRTT_ENRT_RSLT_F

Line 118: from ben_prtt_enrt_rslt_f pen

114:
115: delete from ben_prmry_care_prvdr_f pcp
116: where pcp.prtt_enrt_rslt_id in
117: (select pen.prtt_enrt_rslt_id
118: from ben_prtt_enrt_rslt_f pen
119: where pen.person_id = p_person_id);
120:
121: delete from ben_prmry_care_prvdr_f pcp
122: where pcp.elig_cvrd_dpnt_id in

Line 125: ben_prtt_enrt_rslt_f pen

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:
129: delete from ben_enrt_rt

Line 194: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);

190: where person_id =p_person_id);
191:
192: delete from ben_prtt_prem_f
193: where prtt_enrt_rslt_id in
194: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);
195: delete from ben_prtt_rt_val where prtt_enrt_rslt_id in
196: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);
197:
198: delete from ben_bnft_prvdd_ldgr_f where prtt_enrt_rslt_id in

Line 196: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);

192: delete from ben_prtt_prem_f
193: where prtt_enrt_rslt_id in
194: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);
195: delete from ben_prtt_rt_val where prtt_enrt_rslt_id in
196: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);
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:

Line 199: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);

195: delete from ben_prtt_rt_val where prtt_enrt_rslt_id in
196: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);
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:

Line 202: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);

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
206: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id));

Line 206: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id));

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
210: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id));

Line 210: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id));

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);
214:

Line 213: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);

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

Line 217: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id));

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

Line 220: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);

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);
224:

Line 227: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id));

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);
231:

Line 230: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);

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:
234: delete from ben_per_cm_prvdd_f where per_cm_id in

Line 232: delete 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:
234: delete from ben_per_cm_prvdd_f where per_cm_id in
235: (select per_cm_id from ben_per_cm_f where person_id =p_person_id);
236: