APPS.IBE_M_PRICING_PVT SQL Statements

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

Line: 38

   delete from IBE_TEMP_TABLE where key =p_keyString;

Line: 43

      INSERT into IBE_TEMP_TABLE (KEY, NUM_VAL) VALUES (p_keyString,to_number(l_id_str));

Line: 48

     x_QueryString := 'SELECT NUM_VAL FROM IBE_TEMP_TABLE WHERE KEY = :'||p_number||'';

Line: 80

  l_delete_status  VARCHAR2(10);

Line: 107

    l_stmt := ' SELECT list_header_id, name, description, currency_code '||
              ' FROM QP_LIST_HEADERS_V ' ||
              ' WHERE list_header_id in ( ' || l_query_str || ')';

Line: 130

    l_stmt := ' SELECT list_header_id, name, description, currency_code '||
            ' FROM QP_LIST_HEADERS_V '||
            ' WHERE list_header_id in ' ||
            ' (SELECT T.column_value FROM TABLE(:price_list_id_tbl AS '||
            ' JTF_NUMBER_TABLE) T WHERE T.column_value > 0 AND ' ||
            ' T.column_value < 9.99E125)';

Line: 178

        open x_currency_csr FOR 'SELECT currency_code, name FROM('||l_query_statement||')WHERE LOWER(name) like :p_search_value' USING p_search_value;

Line: 180

        open x_currency_csr FOR 'SELECT currency_code, name FROM(' ||l_query_statement|| ')WHERE LOWER(currency_code) like :p_search_value' USING p_search_value;