APPS.AR_PURGE dependencies on AR_CUSTOMER_CALL_TOPICS

Line 4432: ar_customer_call_topics topics

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
4436: ) ;

Line 4442: FROM ar_customer_call_topics topics

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
4443: WHERE topics.customer_trx_id = p_entity_id
4444: ) ;
4445: --
4446: DELETE FROM ar_customer_call_topics

Line 4446: DELETE FROM ar_customer_call_topics

4442: FROM ar_customer_call_topics topics
4443: WHERE topics.customer_trx_id = p_entity_id
4444: ) ;
4445: --
4446: DELETE FROM ar_customer_call_topics
4447: WHERE customer_trx_id = p_entity_id ;
4448: --
4449: UPDATE ar_correspondences corr
4450: SET corr.purged_children_flag = 'Y'