APPS.BEN_DM_DELETE dependencies on BEN_PER_CM_F

Line 235: (select per_cm_id from ben_per_cm_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:
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:

Line 238: (select per_cm_id from ben_per_cm_f where person_id =p_person_id);

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:

Line 241: (select per_cm_id from ben_per_cm_f where person_id =p_person_id);

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;

Line 243: delete 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;
246:
247: delete from ben_ptnl_ler_for_per where person_id =p_person_id;