The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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;
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;
SELECT score_comp_value
FROM iex_score_comp_types_b
WHERE score_comp_type_id = p_score_comp_type_id;
/*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;*/
/*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;*/
/* 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;*/