APPS.OE_HEADER_STATUS_PUB dependencies on WF_PROCESS_ACTIVITIES

Line 79: FROM wf_item_activity_statuses wias, wf_process_activities wpa

75: Get_Cancelled_Status(p_header_id => p_header_id, x_result => x_result);
76: IF x_result = 'Y' THEN
77: SELECT end_date
78: INTO x_result_date
79: FROM wf_item_activity_statuses wias, wf_process_activities wpa
80: WHERE wias.item_type = OE_GLOBALS.G_WFI_HDR
81: AND wias.item_key = to_char(p_header_id)
82: AND wias.process_activity = wpa.instance_id
83: AND wpa.activity_name = 'CLOSE_HEADER';

Line 240: FROM wf_item_activity_statuses wias, wf_process_activities wpa

236: Get_Closed_Status(p_header_id => p_header_id, x_result => x_result);
237: IF x_result = 'Y' THEN
238: SELECT end_date
239: INTO x_result_date
240: FROM wf_item_activity_statuses wias, wf_process_activities wpa
241: WHERE wias.item_type = OE_GLOBALS.G_WFI_HDR
242: AND wias.item_key = to_char(p_header_id)
243: AND wias.process_activity = wpa.instance_id
244: AND wpa.activity_name = 'CLOSE_HEADER';