APPS.OE_LINE_UTIL dependencies on WF_PROCESS_ACTIVITIES

Line 19253: , WF_PROCESS_ACTIVITIES WPA

19249:
19250: CURSOR ship_authorize IS
19251: SELECT 'Y' from
19252: WF_ITEM_ACTIVITY_STATUSES WIAS
19253: , WF_PROCESS_ACTIVITIES WPA
19254: where WIAS.item_type = 'OEOL'
19255: AND WIAS.item_key = to_char(p_x_line_rec.line_id)
19256: AND WIAS.activity_status = 'NOTIFIED'
19257: AND WPA.activity_name = 'AUTHORIZE_TO_SHIP_WAIT'

Line 19608: wf_process_activities p

19604: IF nvl(p_x_line_rec.cancelled_flag,'N') = 'Y' THEN
19605: oe_debug_pub.add(' Line is cancelled, Close_Line WF act is ? ');
19606: select count(*) into l_close_act_complete
19607: from wf_item_activity_statuses s,
19608: wf_process_activities p
19609: where s.process_activity = p.instance_id
19610: and s.item_type = 'OEOL'
19611: and s.item_key = to_char(p_x_line_rec.line_id)
19612: and p.activity_name = 'CLOSE_LINE'

Line 24472: wf_process_activities wpa

24468: BEGIN
24469: SELECT ACTIVITY_STATUS
24470: INTO l_activity_status_code
24471: FROM wf_item_activity_statuses wias,
24472: wf_process_activities wpa
24473: WHERE wias.item_type = 'OEOL'
24474: AND wias.item_key = to_char(p_link_to_line_id)
24475: AND wias.process_activity = wpa.instance_id
24476: AND wpa.activity_item_type = 'OEOL'