APPS.GMF_GET_OPM_CODE SQL Statements

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

Line: 16

       select count(*)
       from op_fobc_mst
       where fob_code = p_original_code;

Line: 21

       select count(*)
       from op_term_mst
       where terms_code = p_original_code;

Line: 26

       select count(*)
       from op_frgt_mth
       where frtbill_mthd = p_original_code;

Line: 31

       select count(*)
       from op_ship_mst
       where shipper_code = p_original_code;

Line: 38

       select count (*)
       from gl_rate_typ
       where rate_type_code = p_original_code;

Line: 54

procedure insert_code (p_original_code varchar2);

Line: 144

      insert_code(p_original_code);

Line: 147

      insert_code(p_original_code);

Line: 156

procedure insert_code(p_original_code varchar2)  is
l_table_index	binary_integer;

Line: 165

  end insert_code;

Line: 172

function delete_session_codes_tab
         return number is
begin
  g_session_code_tab.delete;

Line: 182

end delete_session_codes_tab;

Line: 197

        g_session_code_tab.delete(l_table_index);