DBA Data[Home] [Help]

APPS.OKE_AUTHORING_UTILS SQL Statements

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

Line: 15

      SELECT from_table
      FROM jtf_objects_vl
      WHERE object_code = p_object_code
      AND sysdate between nvl(start_date_active , sysdate-1)
                  and     nvl(end_date_active , sysdate+1);
Line: 22

        SELECT 1 FROM USER_TAB_COLUMNS
        WHERE table_name = l_view_name
        AND column_name = p_column_name;
Line: 114

	l_sql_stmt := 'SELECT PARTY_ID FROM '|| l_sql_stmt;