APPS.IEX_METRIC_PVT SQL Statements

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

Line: 37

      SELECT score_comp_type_id, score_comp_name, score_comp_value
      FROM iex_score_comp_types_vl
      WHERE active_flag = 'Y'
      AND metric_flag = 'Y'
      AND jtf_object_code = NVL(p_filter_by_object, jtf_object_code)
      ORDER BY display_order;

Line: 61

      SELECT low_from, low_to, medium_from, medium_to, high_from, high_to
      FROM iex_metric_ratings
      WHERE score_comp_type_id = x_score_comp_type_id;

Line: 72

   SELECT  gll.currency_code,
           c.precision,
           c.minimum_accountable_unit,
	   TRUNC(add_months(sysdate, - 12)) pastYearFrom ,
           TRUNC(sysdate) pastYearTo
    FROM    ar_system_parameters    sp,
            gl_ledgers_public_v     gll,
	    fnd_currencies     c
    WHERE   gll.ledger_id = sp.set_of_books_id
    AND    gll.currency_code   = c.currency_code;

Line: 366

      SELECT score_comp_value
      FROM iex_score_comp_types_b
      WHERE score_comp_type_id = p_score_comp_type_id;

Line: 553

  /*SELECT gll.currency_code,
         c.precision,
         c.minimum_accountable_unit
    INTO   g_curr_rec.base_currency,
           g_curr_rec.base_precision,
           g_curr_rec.base_min_acc_unit
    FROM   ar_system_parameters   sysp,
           gl_ledgers_public_v    gll,
           fnd_currencies     c
   WHERE  gll.ledger_id = sysp.set_of_books_id
     AND    gll.currency_code   = c.currency_code;*/

Line: 565

  /*SELECT sob.currency_code,
         c.precision,
         c.minimum_accountable_unit
    INTO   g_curr_rec.base_currency,
           g_curr_rec.base_precision,
           g_curr_rec.base_min_acc_unit
    FROM   ar_system_parameters   sysp,
           gl_sets_of_books     sob,
           fnd_currencies     c
   WHERE  sob.set_of_books_id = sysp.set_of_books_id
     AND    sob.currency_code   = c.currency_code;*/

Line: 581

 /* SELECT  TRUNC(add_months(sysdate, - 12)) pastYearFrom ,
          TRUNC(sysdate) pastYearTo
    INTO  g_curr_rec.past_year_from,
          g_curr_rec.past_year_to
    FROM  dual;*/