The following lines contain the word 'select', 'insert', 'update' or 'delete':
select SET_OF_BOOKS_ID
into SOB_ID
from CN_REPOSITORIES;
SELECT s.currency_code
INTO x_currency_code
FROM gl_sets_of_books s
,cn_repositories_all r
WHERE r.set_of_books_id = s.set_of_books_id
AND r.application_id = 283
AND r.org_id = p_org_id
;
SELECT s.currency_code
INTO x_currency_code
FROM gl_sets_of_books s
,cn_repositories r
WHERE r.set_of_books_id = s.set_of_books_id
AND r.application_id = 283
;
SELECT period_id
INTO X_period_id
FROM cn_periods
WHERE X_period_date BETWEEN trunc(start_date)
AND trunc(end_date)
;
SELECT p.period_id
,p.period_status
,p.period_name
,p.start_date
,p.end_date
INTO x_period_id
,x_period_status
,x_period_name
,x_start_date
,x_end_date
FROM cn_periods p
WHERE ( x_period_date IS NULL
OR x_period_date BETWEEN trunc(p.start_date)
AND trunc(p.end_date) )
AND ( x_period_name IS NULL
OR x_period_name = p.period_name)
AND ( x_period_id IS NULL
OR x_period_id = p.period_id)
;
SELECT period_name
INTO X_period_name
FROM cn_periods
WHERE period_id = X_period_id
;
SELECT meaning
INTO X_meaning
FROM cn_lookups
WHERE lookup_code = X_lookup_code
AND lookup_type = X_lookup_type;
SELECT name
,employee_number
INTO x_name
,x_employee_number
FROM cn_salesreps
WHERE salesrep_id = X_Salesrep_id
;
SELECT user_name
INTO X_username
FROM fnd_user
WHERE user_id = X_userid;
SELECT period_id
FROM cn_acc_period_statuses_v
WHERE p_date BETWEEN start_date AND end_date
AND org_id = p_org_id;
SELECT MIN(period_id)
FROM cn_acc_period_statuses_v
WHERE period_status = 'O'
AND org_id = p_org_id;