3563: WHERE call_action_id IN
3564: (
3565: SELECT call.call_action_id
3566: FROM ar_call_actions call,
3567: ar_customer_call_topics topics
3568: WHERE topics.customer_trx_id = p_entity_id
3569: AND topics.customer_call_topic_id =
3570: call.customer_call_topic_id
3571: ) ;
3573: DELETE FROM ar_call_actions call
3574: WHERE customer_call_topic_id IN
3575: (
3576: SELECT topics.customer_call_topic_id
3577: FROM ar_customer_call_topics topics
3578: WHERE topics.customer_trx_id = p_entity_id
3579: ) ;
3580: --
3581: DELETE FROM ar_customer_call_topics
3577: FROM ar_customer_call_topics topics
3578: WHERE topics.customer_trx_id = p_entity_id
3579: ) ;
3580: --
3581: DELETE FROM ar_customer_call_topics
3582: WHERE customer_trx_id = p_entity_id ;
3583: --
3584: UPDATE ar_correspondences corr
3585: SET corr.purged_children_flag = 'Y'