[Home] [Help]
4427: DELETE FROM ar_action_notifications action
4428: WHERE call_action_id IN
4429: (
4430: SELECT call.call_action_id
4431: FROM ar_call_actions call,
4432: ar_customer_call_topics topics
4433: WHERE topics.customer_trx_id = p_entity_id
4434: AND topics.customer_call_topic_id =
4435: call.customer_call_topic_id
4434: AND topics.customer_call_topic_id =
4435: call.customer_call_topic_id
4436: ) ;
4437: --
4438: DELETE FROM ar_call_actions call
4439: WHERE customer_call_topic_id IN
4440: (
4441: SELECT topics.customer_call_topic_id
4442: FROM ar_customer_call_topics topics