APPS.HRI_BPL_OE_ORDER SQL Statements

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

Line: 9

PROCEDURE UPDATE_GLOBALS(p_line_id IN NUMBER)
IS
  CURSOR csr_line_order
  IS
    select
      ool.header_id    l_header_id,
      ool.line_number  l_line_number,
      ooh.order_number l_order_number
    from
      oe_order_headers_all          ooh,
      oe_order_lines_all            ool
    where
      p_line_id         = ool.line_id
      AND ool.header_id = ooh.header_id;

Line: 35

END UPDATE_GLOBALS;

Line: 52

      UPDATE_GLOBALS
        (p_line_id
        );

Line: 74

      UPDATE_GLOBALS
        (p_line_id
        );

Line: 96

      UPDATE_GLOBALS
        (p_line_id
        );