DBA Data[Home] [Help]

APPS.AZW_HIER dependencies on WF_NOTIFICATIONS

Line 1277: wf_notifications wn

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
1281: AND wna.notification_id = wias.notification_id

Line 1290: wf_notifications wn

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
1294: AND wna.notification_id = wias.notification_id