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:
237: delete from ben_per_cm_trgr_f where per_cm_id in
238: (select per_cm_id from ben_per_cm_f where person_id =p_person_id);
239:
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:
237: delete from ben_per_cm_trgr_f where per_cm_id in
238: (select per_cm_id from ben_per_cm_f where person_id =p_person_id);
239:
240: delete from ben_per_cm_usg_f where per_cm_id in
241: (select per_cm_id from ben_per_cm_f where person_id =p_person_id);
242:
237: delete from ben_per_cm_trgr_f where per_cm_id in
238: (select per_cm_id from ben_per_cm_f where person_id =p_person_id);
239:
240: delete from ben_per_cm_usg_f where per_cm_id in
241: (select per_cm_id from ben_per_cm_f where person_id =p_person_id);
242:
243: delete from ben_per_cm_f where person_id =p_person_id;
244:
245: delete from ben_per_in_ler where person_id =p_person_id;
239:
240: delete from ben_per_cm_usg_f where per_cm_id in
241: (select per_cm_id from ben_per_cm_f where person_id =p_person_id);
242:
243: delete from ben_per_cm_f where person_id =p_person_id;
244:
245: delete from ben_per_in_ler where person_id =p_person_id;
246:
247: delete from ben_ptnl_ler_for_per where person_id =p_person_id;