DBA Data[Home] [Help]

APPS.AZW_PROC dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 2184: FROM wf_item_activity_statuses wias, wf_notification_attributes wna,

2180: ORDER BY wias.begin_date desc;
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

Line 2197: FROM wf_item_activity_statuses wias, wf_notification_attributes wna,

2193: AND wna.text_value LIKE '%DONE%';
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