APPS.POR_UTIL_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1023: from wf_item_activity_statuses

1019: and parent_item_key = l_wf_itemkey;
1020:
1021: cursor wf_notifs (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
1022: select notification_id
1023: from wf_item_activity_statuses
1024: where item_type = l_wf_itemtype
1025: and item_key = l_wf_itemkey
1026: and notification_id is not null;
1027:

Line 2466: FROM wf_item_activity_statuses wfs,

2462:
2463: BEGIN
2464: SELECT NVL(activity_status, 'N')
2465: INTO l_activity_status
2466: FROM wf_item_activity_statuses wfs,
2467: wf_items wfi,
2468: wf_process_activities wfa
2469: WHERE wfi.item_type = l_item_type
2470: and wfi.item_key = l_item_key

Line 2505: FROM wf_item_activity_statuses wfs,

2501:
2502: BEGIN
2503: SELECT NVL(activity_status, 'N')
2504: INTO l_activity_status
2505: FROM wf_item_activity_statuses wfs,
2506: wf_items wfi,
2507: wf_process_activities wfa
2508: WHERE wfi.item_type = l_item_type
2509: and wfi.item_key = c1_rec.item_key

Line 3231: from wf_item_activity_statuses stat,

3227: PROCEDURE cancel_workflow(p_headerId in NUMBER) IS
3228:
3229: cursor c1(itemtype varchar2, itemkey varchar2) is
3230: select stat.notification_id
3231: from wf_item_activity_statuses stat,
3232: wf_items item
3233: where stat.item_type = itemtype
3234: AND item.item_type = itemtype
3235: AND item.parent_item_key = itemkey

Line 3240: from wf_item_activity_statuses

3236: AND stat.item_key = item.item_key
3237: AND stat.activity_status = 'NOTIFIED'
3238: UNION
3239: select notification_id
3240: from wf_item_activity_statuses
3241: where item_type = itemtype
3242: AND item_key = itemkey
3243: AND activity_status = 'NOTIFIED'
3244: AND notification_id is NOT NULL;