DBA Data[Home] [Help]

APPS.AZW_HIER dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 1276: FROM wf_item_activity_statuses wias, wf_notification_attributes wna,

1272: ORDER BY wfi.begin_date;
1273:
1274: CURSOR az_steps_count_cursor IS
1275: SELECT COUNT(*)
1276: FROM wf_item_activity_statuses wias, wf_notification_attributes wna,
1277: wf_notifications wn
1278: WHERE wias.item_type = v_item_type
1279: AND wias.item_key = v_item_key
1280: AND wias.notification_id IS NOT NULL

Line 1289: FROM wf_item_activity_statuses wias, wf_notification_attributes wna,

1285: AND wna.text_value LIKE '%DONE%';
1286:
1287: CURSOR az_skip_count_cursor IS
1288: SELECT COUNT(*)
1289: FROM wf_item_activity_statuses wias, wf_notification_attributes wna,
1290: wf_notifications wn
1291: WHERE wias.item_type = v_item_type
1292: AND wias.item_key = v_item_key
1293: AND wias.notification_id is not NULL