APPS.OE_ORDER_BOOK_UTIL dependencies on WF_PROCESS_ACTIVITIES

Line 25: , WF_PROCESS_ACTIVITIES WPA

21: l_book_deferred VARCHAR2(1);
22: CURSOR book_deferred IS
23: SELECT 'Y'
24: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
25: , WF_PROCESS_ACTIVITIES WPA
26: WHERE WIAS.item_type = 'OEOH'
27: AND WIAS.item_key = p_itemkey
28: AND WIAS.activity_status = 'DEFERRED'
29: AND WPA.activity_name = 'BOOK_DEFER'

Line 1407: , WF_PROCESS_ACTIVITIES WPA

1403: l_source_document_id NUMBER;
1404: CURSOR book_eligible IS
1405: SELECT 'Y'
1406: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
1407: , WF_PROCESS_ACTIVITIES WPA
1408: WHERE WIAS.item_type = 'OEOH'
1409: AND WIAS.item_key = l_itemkey
1410: AND WIAS.activity_status = 'NOTIFIED'
1411: AND WPA.activity_name = 'BOOK_ELIGIBLE'

Line 1417: , WF_PROCESS_ACTIVITIES WPA

1413: --For bug 3493374
1414: CURSOR booking_errored IS
1415: SELECT 'Y'
1416: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
1417: , WF_PROCESS_ACTIVITIES WPA
1418: WHERE WIAS.item_type = 'OEOH'
1419: AND WIAS.item_key = l_itemkey
1420: AND WIAS.activity_status = 'ERROR'
1421: AND WPA.activity_name = 'BOOK_ORDER'