APPS.AST_SEARCHURL_PVT SQL Statements

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

Line: 51

      SELECT search_id, search_url, next_page_ident, max_nbr_pages
      FROM ast_web_searches
      WHERE search_id = x_search_id
	 AND UPPER(enabled_flag) = 'Y';

Line: 61

      SELECT query_string_id, switch_separator, url_separator, header_const, trailer_const
      FROM ast_query_strings
      WHERE search_id = x_search_id
      AND UPPER(enabled_flag) = 'Y';

Line: 67

      SELECT cgi_switch_id, switch_code, switch_type
      FROM ast_cgi_switches
      WHERE query_string_id = x_query_string_id
      AND UPPER(enabled_flag) = 'Y'
      ORDER BY sort_order;

Line: 74

      SELECT first_name_yn, last_name_yn, address_yn, city_yn, state_yn, country_yn, zip_yn
      FROM ast_switch_data
      WHERE cgi_switch_id = x_cgi_switch_id;