APPS.IBE_M_PRICING_PVT SQL Statements

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

Line: 41

  l_delete_status  VARCHAR2(10);

Line: 66

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

Line: 89

    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: 121

        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: 123

        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;