DBA Data[Home] [Help]

APPS.FTP_CONDITION_PVT SQL Statements

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

Line: 16

  l_select_stmt     VARCHAR2(500);
Line: 24

  SELECT member_vl_object_name, member_col, member_name_col
  INTO l_member_table, l_member_id_col, l_member_name_col
  FROM fem_xdim_dimensions
  WHERE dimension_id = p_dimension_id;
Line: 29

  l_select_stmt := 'SELECT ' || l_member_name_col ||
                   ' FROM '  || l_member_table ||
                   ' WHERE ' || l_member_id_col || '=:member_id';
Line: 34

  DBMS_SQL.PARSE(l_cursor_id, l_select_stmt, DBMS_SQL.NATIVE);