The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT gsob.currency_code from_currency
FROM cn_repositories_all repo,
gl_sets_of_books gsob
WHERE repo.org_id = p_org_id
AND repo.application_id = 283
AND repo.set_of_books_id = gsob.set_of_books_id;
SELECT (p_end_date - p_start_date + 1) prorated_days
FROM dual;
SELECT rs.org_id, rs.salesrep_id, hou.name operating_unit
FROM jtf_rs_salesreps rs, jtf_rs_resource_extns rre,
hr_operating_units hou
WHERE rre.source_id = p_person_id
AND rre.resource_id = rs.resource_id
AND rre.category = 'EMPLOYEE'
AND rs.org_id = hou.organization_id;
SELECT min(period_id) start_period_id, max(period_id) end_period_id,
min(start_date) new_start_date, max(end_date) new_end_date,
(max(end_date) - min(start_date) + 1) total_days
FROM cn_period_statuses_all
WHERE start_date <= p_end_date
AND p_start_date <= end_date
AND org_id = p_org_id
ORDER BY period_id;
SELECT NVL(SUM(NVL(balance2_dtd,0)),0) commission,
NVL(SUM(NVL(balance1_dtd,0) - NVL(balance1_ctd,0)),0) paid_pmt
FROM cn_srp_periods_all
WHERE salesrep_id = p_salesrep_id
AND period_id BETWEEN p_start_period_id AND p_end_period_id
AND credit_type_id = g_credit_type_id
AND quota_id IS NULL
AND org_id = p_org_id;