APPS.EDR_PSIG_PAGE_FLOW dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 957: from wf_item_activity_statuses where item_type=p_itemtype

953: if(lc_itemkey <> p_itemkey and lp_status = 'ACTIVE' ) then
954: BEGIN
955:
956: select notification_id into lp_notification_id
957: from wf_item_activity_statuses where item_type=p_itemtype
958: and item_key = lc_itemkey and notification_id is not null
959: and activity_status ='NOTIFIED';
960:
961: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1441: SELECT NOTIFICATION_ID from WF_ITEM_ACTIVITY_STATUSES_V

1437: AND NOTIFICATION_STATUS = 'OPEN'
1438: ORDER BY BEGIN_DATE DESC;
1439: */
1440: CURSOR CUR_NOTIFICATION IS
1441: SELECT NOTIFICATION_ID from WF_ITEM_ACTIVITY_STATUSES_V
1442: WHERE ITEM_KEY = p_itemkey
1443: AND ITEM_TYPE = p_itemtype
1444: AND notification_id is not null
1445: ORDER BY activity_begin_date, execution_time;