APPS.WIP_EXP_NOTIF_WF_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 33

    select
      wen.wip_entity_name, we.operation_seq_num, br.resource_code, msi.concatenated_segments
    into
      l_job_name, l_op_seq_num, l_res_name, l_comp_name
    from
      wip_exceptions we, wip_entities wen, bom_resources br, mtl_system_items_vl msi
    where
      we.organization_id = wen.organization_id and
      we.wip_entity_id = wen.wip_entity_id and
      we.organization_id = br.organization_id(+) and
      we.resource_id = br.resource_id (+) and
      we.organization_id = msi.organization_id(+) and
      we.component_item_id = msi.inventory_item_id (+) and
      we.exception_id = p_exception_id;

Line: 48

    select to_char(WIP_EXP_NOTIF_WF_ITEMKEY_S.NEXTVAL)
      into l_seq from sys.dual;

Line: 133

  select exception_type into l_exception_type from wip_exceptions where exception_id = l_exception_id ;