APPS.OE_DEALS_UTIL dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 10: FROM WF_ITEM_ACTIVITY_STATUSES WIAS

6: l_activity varchar2(30);
7: BEGIN
8:
9: SELECT WPA.activity_name INTO l_activity
10: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
11: , WF_PROCESS_ACTIVITIES WPA
12: WHERE WIAS.item_type = p_item_type
13: AND WIAS.item_key = p_item_key
14: AND WIAS.activity_status = 'NOTIFIED'

Line 479: FROM WF_ITEM_ACTIVITY_STATUSES WIAS

475: l_result varchar2(10);
476:
477: CURSOR Compliance_eligible IS
478: SELECT 'Y'
479: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
480: , WF_PROCESS_ACTIVITIES WPA
481: WHERE WIAS.item_type = p_item_type
482: AND WIAS.item_key = l_itemkey
483: AND WIAS.activity_status = 'NOTIFIED'

Line 489: FROM WF_ITEM_ACTIVITY_STATUSES WIAS

485: AND WPA.instance_id = WIAS.process_activity;
486:
487: CURSOR Compliance_errored IS
488: SELECT 'Y'
489: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
490: , WF_PROCESS_ACTIVITIES WPA
491: WHERE WIAS.item_type = p_item_type
492: AND WIAS.item_key = l_itemkey
493: AND WIAS.activity_status = 'ERROR'

Line 1250: FROM WF_ITEM_ACTIVITY_STATUSES WIAS

1246: --there can be 2 cases--Direct approve without submit-- so progress both activity
1247: --and submit-approve - progress only submit WF activity
1248: BEGIN
1249: select WPA.activity_name INTO l_wf_activity
1250: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
1251: , WF_PROCESS_ACTIVITIES WPA
1252: WHERE WIAS.item_type = p_item_type
1253: AND WIAS.item_key = to_char(p_header_id)
1254: AND WIAS.activity_status = 'NOTIFIED'