DBA Data[Home] [Help]

APPS.AR_PURGE dependencies on AR_CALL_ACTIONS

Line 3566: FROM ar_call_actions call,

3562: DELETE FROM ar_action_notifications action
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

Line 3573: DELETE FROM ar_call_actions call

3569: AND topics.customer_call_topic_id =
3570: call.customer_call_topic_id
3571: ) ;
3572: --
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