DBA Data[Home] [Help]

APPS.ECX_STANDARD SQL Statements

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

Line: 1187

  select  ecx_trigger_id_s.NEXTVAL
  from    dual;
Line: 1346

       select name
       into   i_from_system_name
       from   wf_systems
       where  guid = wf_core.translate('WF_SYSTEM_GUID');
Line: 2088

   select payload
   from   ecx_dtds
   where  filename = i_dtd_file_name
   and    root_element = i_dtd_root_element
   and    (version = i_dtd_version or i_dtd_version is null);
Line: 2122

         select max(version)
         into   i_version
         from   ecx_files
         where   application_code = i_xslt_application_code
         and     name = i_xslt_file_name
         and    type = 'XSLT';
Line: 2294

    l_node_list := XSLPROCESSOR.selectNodes(XMLDOM.makeNode(l_dom_document),p_XPATH_EXPRESSION);