APPS.GL_FLATTEN_SETUP_DATA SQL Statements

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

Line: 205

      SELECT bal_seg_value_set_id, mgt_seg_value_set_id
      INTO   GLSTFL_BAL_VS_ID, GLSTFL_MGT_VS_ID
      FROM   GL_LEDGERS
      WHERE  chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
      AND    rownum = 1;

Line: 293

      UPDATE GL_LEDGER_NORM_SEG_VALS
      SET request_id = GLSTFL_REQ_ID
      WHERE status_code is NOT NULL
      AND   ledger_id IN ( SELECT LEDGER_ID FROM GL_LEDGERS
                           WHERE chart_of_accounts_id =
                                    GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);

Line: 326

      UPDATE GL_LEDGER_SET_NORM_ASSIGN
      SET request_id = GLSTFL_REQ_ID
      WHERE status_code is NOT NULL;

Line: 356

      UPDATE GL_ACCESS_SET_NORM_ASSIGN
      SET request_id = GLSTFL_REQ_ID
      WHERE status_code is NOT NULL;

Line: 1000

      SELECT fvt.application_table_name,
             fvt.value_column_name
      INTO   tab_name,col_name
      FROM   fnd_flex_validation_tables fvt,
             fnd_flex_value_sets fvs
      WHERE  fvs.flex_value_set_id = X_vs_id
      AND    fvs.validation_type = 'F'
      AND    fvt.flex_value_set_id = fvs.flex_value_set_id;