DBA Data[Home] [Help]

APPS.CAC_SR_UTIL_PVT SQL Statements

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

Line: 10

     SELECT select_id, select_name, from_table, where_clause
       FROM jtf_objects_b
      WHERE object_code = p_object_type_code;
Line: 16

      l_id_column      jtf_objects_b.select_id%TYPE;
Line: 17

      l_name_column    jtf_objects_b.select_name%TYPE;
Line: 45

    sql_stmt := ' SELECT ' ||
          l_name_column ||
          ' from ' ||
          l_from_clause ||
          '  where ' ||
          l_where_clause ||
          l_id_column ||
          ' = :object_id and rownum = 1';