DBA Data[Home] [Help]

APPS.BIS_GRAPH_REGION_HTML_FORMS SQL Statements

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

Line: 230

    SELECT
      web_html_call
      , parameters
      INTO
      l_function_web_call
      , l_function_parameters
      FROM fnd_form_functions
      WHERE function_id = l_function_id;
Line: 514

 select  a.menu_id
 from fnd_responsibility a,
   fnd_user_resp_groups b
 where b.user_id = pUserId
   and   a.version = 'W'
   and   b.responsibility_id = a.responsibility_id
   and   b.start_date <= sysdate
   and   (b.end_date is null or b.end_date >= sysdate)
   and    a.start_date <= sysdate
   and   (a.end_date is null or a.end_date >= sysdate);
Line: 534

		select function_id, web_html_call
		into l_function_id, l_web_html_call
		from fnd_form_functions
		where function_name = pFunctionName;