APPS.EDR_PSIG_PAGE_FLOW dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 943: from wf_item_activity_statuses where item_type=p_itemtype

939:
940: if(lc_itemkey <> p_itemkey and lp_status = 'ACTIVE' ) then
941:
942: select notification_id into lp_notification_id
943: from wf_item_activity_statuses where item_type=p_itemtype
944: and item_key = lc_itemkey and notification_id is not null
945: and activity_status ='NOTIFIED';
946:
947:

Line 1419: SELECT NOTIFICATION_ID from WF_ITEM_ACTIVITY_STATUSES_V

1415: AND NOTIFICATION_STATUS = 'OPEN'
1416: ORDER BY BEGIN_DATE DESC;
1417: */
1418: CURSOR CUR_NOTIFICATION IS
1419: SELECT NOTIFICATION_ID from WF_ITEM_ACTIVITY_STATUSES_V
1420: WHERE ITEM_KEY = p_itemkey
1421: AND ITEM_TYPE = p_itemtype
1422: AND notification_id is not null
1423: ORDER BY activity_begin_date, execution_time;