APPS.BEN_DM_DELETE dependencies on BEN_ELIG_PER_F

Line 250: (select elig_per_id from ben_elig_per_f where person_id =p_person_id);

246:
247: delete from ben_ptnl_ler_for_per where person_id =p_person_id;
248:
249: delete from ben_elig_per_opt_f where elig_per_id in
250: (select elig_per_id from ben_elig_per_f where person_id =p_person_id);
251:
252: delete from ben_elig_per_f where person_id =p_person_id;
253:
254: -- delete from extrat

Line 252: delete from ben_elig_per_f where person_id =p_person_id;

248:
249: delete from ben_elig_per_opt_f where elig_per_id in
250: (select elig_per_id from ben_elig_per_f where person_id =p_person_id);
251:
252: delete from ben_elig_per_f where person_id =p_person_id;
253:
254: -- delete from extrat
255: delete from ben_ext_rslt_dtl where person_id=p_person_id;
256: delete from ben_ext_rslt_err where person_id=p_person_id;