DBA Data[Home] [Help]

APPS.AR_PURGE dependencies on AR_CUSTOMER_CALL_TOPICS

Line 3567: ar_customer_call_topics topics

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

Line 3577: FROM ar_customer_call_topics topics

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

Line 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'