APPS.WIP_EXP_NOTIF_WF_PKG dependencies on WIP_EXCEPTIONS

Line 38: wip_exceptions we, wip_entities wen, bom_resources br, mtl_system_items_vl msi

34: wen.wip_entity_name, we.operation_seq_num, br.resource_code, msi.concatenated_segments
35: into
36: l_job_name, l_op_seq_num, l_res_name, l_comp_name
37: from
38: wip_exceptions we, wip_entities wen, bom_resources br, mtl_system_items_vl msi
39: where
40: we.organization_id = wen.organization_id and
41: we.wip_entity_id = wen.wip_entity_id and
42: we.organization_id = br.organization_id(+) and

Line 133: select exception_type into l_exception_type from wip_exceptions where exception_id = l_exception_id ;

129: itemkey => itemkey,
130: aname => 'EXCEPTION_ID');
131: x_progress := '2';
132:
133: select exception_type into l_exception_type from wip_exceptions where exception_id = l_exception_id ;
134:
135: x_progress := '3';
136:
137: if (l_exception_type = 1) then