APPS.OE_LINE_UTIL dependencies on WF_PROCESS_ACTIVITIES

Line 17547: , WF_PROCESS_ACTIVITIES WPA

17543:
17544: CURSOR ship_authorize IS
17545: SELECT 'Y' from
17546: WF_ITEM_ACTIVITY_STATUSES WIAS
17547: , WF_PROCESS_ACTIVITIES WPA
17548: where WIAS.item_type = 'OEOL'
17549: AND WIAS.item_key = to_char(p_x_line_rec.line_id)
17550: AND WIAS.activity_status = 'NOTIFIED'
17551: AND WPA.activity_name = 'AUTHORIZE_TO_SHIP_WAIT'

Line 17830: wf_process_activities p

17826: IF nvl(p_x_line_rec.cancelled_flag,'N') = 'Y' THEN
17827: oe_debug_pub.add(' Line is cancelled, Close_Line WF act is ? ');
17828: select count(*) into l_close_act_complete
17829: from wf_item_activity_statuses s,
17830: wf_process_activities p
17831: where s.process_activity = p.instance_id
17832: and s.item_type = 'OEOL'
17833: and s.item_key = to_char(p_x_line_rec.line_id)
17834: and p.activity_name = 'CLOSE_LINE'

Line 22588: wf_process_activities wpa

22584: BEGIN
22585: SELECT ACTIVITY_STATUS
22586: INTO l_activity_status_code
22587: FROM wf_item_activity_statuses wias,
22588: wf_process_activities wpa
22589: WHERE wias.item_type = 'OEOL'
22590: AND wias.item_key = to_char(p_link_to_line_id)
22591: AND wias.process_activity = wpa.instance_id
22592: AND wpa.activity_item_type = 'OEOL'