DBA Data[Home] [Help]

APPS.AZW_PROC dependencies on WF_NOTIFICATIONS

Line 2185: wf_notifications wn

2181:
2182: CURSOR az_steps_count_cursor IS
2183: SELECT COUNT(*)
2184: FROM wf_item_activity_statuses wias, wf_notification_attributes wna,
2185: wf_notifications wn
2186: WHERE wias.item_type = p_type
2187: AND wias.item_key = p_key
2188: AND wias.notification_id IS NOT NULL
2189: AND wna.notification_id = wias.notification_id

Line 2198: wf_notifications wn

2194:
2195: CURSOR az_skip_count_cursor IS
2196: SELECT COUNT(*)
2197: FROM wf_item_activity_statuses wias, wf_notification_attributes wna,
2198: wf_notifications wn
2199: WHERE wias.item_type = p_type
2200: AND wias.item_key = p_key
2201: AND wias.notification_id is not NULL
2202: AND wna.notification_id = wias.notification_id