APPS.XNP_CVU_PKG dependencies on XNP_MSG_ACKS

Line 1552: FROM xnp_msg_acks ma

1548: SELECT tp.timer_publisher_id, tp.source_message_code, tp.timer_message_code
1549: FROM xnp_timer_publishers tp
1550: WHERE NOT EXISTS
1551: (SELECT 1
1552: FROM xnp_msg_acks ma
1553: WHERE ma.source_msg_code = tp.source_message_code
1554: AND ma.ack_msg_code = tp.timer_message_code );
1555:
1556: BEGIN

Line 2665: FROM wf_activity_attr_values ack_aav, xnp_msg_acks ack_xma

2661: AND ats.result_code <> '*'
2662: AND NOT EXISTS
2663: (
2664: SELECT 1
2665: FROM wf_activity_attr_values ack_aav, xnp_msg_acks ack_xma
2666: WHERE
2667: -- Join with the outer SQL
2668: ack_aav.process_activity_id = pa.instance_id
2669: AND ack_xma.ack_msg_code = ats.result_code

Line 2672: -- activity_attr_values -> xnp_msg_acks

2668: ack_aav.process_activity_id = pa.instance_id
2669: AND ack_xma.ack_msg_code = ats.result_code
2670: -- filter for attribute name
2671: AND ack_aav.name = gc_EVENT_TYPE
2672: -- activity_attr_values -> xnp_msg_acks
2673: AND ack_aav.text_value = ack_xma.source_msg_code)
2674:
2675: ORDER BY pa.process_item_type, pa.process_name, pa.process_version;
2676: