The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT MESSAGE_TEXT
FROM FND_NEW_MESSAGES
WHERE LANGUAGE_CODE = 'US'
AND MESSAGE_NAME LIKE p_name;
SELECT MESSAGE_TEXT
FROM FND_NEW_MESSAGES
WHERE LANGUAGE_CODE = 'US'
AND MESSAGE_NAME LIKE p_name;
SELECT PRECISION
FROM fnd_currencies_vl
WHERE currency_code = p_currency_code
AND enabled_flag = 'Y'
AND NVL(start_date_active, SYSDATE) <= SYSDATE
AND NVL(end_date_active, SYSDATE) >= SYSDATE;
SELECT b.stm_apply_rounding_difference
FROM fnd_lookups a,
OKL_SYS_ACCT_OPTS b
WHERE a.lookup_type = p_lookup_type
AND a.lookup_code = b.stm_apply_rounding_difference;
SELECT authoring_org_id,
currency_code
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT stm_rounding_rule
FROM OKL_SYS_ACCT_OPTS;
SELECT pdt_id, start_date
FROM okl_k_headers_full_v
WHERE id = l_khr_id;
SELECT PRIMARY_STY_ID
FROM OKL_STRM_TMPT_LINES_UV STL
WHERE STL.PRIMARY_YN = 'Y'
AND STL.PDT_ID = l_pdt_id
AND (STL.START_DATE <= l_contract_start_date)
AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND PRIMARY_STY_PURPOSE = p_primary_sty_purpose;
SELECT pdt_id, start_date
FROM okl_k_headers_full_v
WHERE id = l_khr_id;
SELECT PRIMARY_STY_ID
FROM OKL_STRM_TMPT_LINES_UV STL
WHERE STL.PRIMARY_YN = 'Y'
AND STL.PDT_ID = l_pdt_id
AND (STL.START_DATE <= l_contract_start_date)
AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND PRIMARY_STY_PURPOSE = p_primary_sty_purpose;
SELECT pdt.reporting_pdt_id, khr.start_date
FROM okl_k_headers_full_v khr, okl_products pdt
WHERE khr.id = l_khr_id
AND khr.pdt_id = pdt.id;
SELECT PRIMARY_STY_ID
FROM OKL_STRM_TMPT_LINES_UV STL
WHERE STL.PRIMARY_YN = 'Y'
AND STL.PDT_ID = l_pdt_id
AND (STL.START_DATE <= l_contract_start_date)
AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND PRIMARY_STY_PURPOSE = p_primary_sty_purpose;
SELECT pdt.reporting_pdt_id, khr.start_date
FROM okl_k_headers_full_v khr, okl_products pdt
WHERE khr.id = l_khr_id
AND khr.pdt_id = pdt.id;
SELECT PRIMARY_STY_ID
FROM OKL_STRM_TMPT_LINES_UV STL
WHERE STL.PRIMARY_YN = 'Y'
AND STL.PDT_ID = l_pdt_id
AND (STL.START_DATE <= l_contract_start_date)
AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND PRIMARY_STY_PURPOSE = p_primary_sty_purpose;
SELECT pdt_id, start_date
FROM okl_k_headers_full_v
WHERE id = l_khr_id;
SELECT DEPENDENT_STY_ID
FROM OKL_STRM_TMPT_LINES_UV STL
WHERE PRIMARY_YN = 'N'
AND STL.PDT_ID = l_product_id
AND (STL.START_DATE <= l_contract_start_date)
AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND PRIMARY_STY_PURPOSE = p_primary_sty_purpose
AND DEPENDENT_STY_PURPOSE = p_dependent_sty_purpose;
SELECT pdt_id, start_date
FROM okl_k_headers_full_v
WHERE id = l_khr_id;
SELECT DEPENDENT_STY_ID
FROM OKL_STRM_TMPT_LINES_UV STL
WHERE PRIMARY_YN = 'N'
AND STL.PDT_ID = l_product_id
AND (STL.START_DATE <= l_contract_start_date)
AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND PRIMARY_STY_ID = p_primary_sty_id
AND DEPENDENT_STY_PURPOSE = p_dependent_sty_purpose;
SELECT pdt_id, start_date
FROM okl_k_headers_full_v
WHERE id = l_khr_id;
SELECT DEPENDENT_STY_ID
FROM OKL_STRM_TMPT_LINES_UV STL
WHERE PRIMARY_YN = 'N'
AND STL.PDT_ID = l_product_id
AND (STL.START_DATE <= l_contract_start_date)
AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND PRIMARY_STY_PURPOSE = p_primary_sty_purpose
AND DEPENDENT_STY_PURPOSE = p_dependent_sty_purpose;
SELECT pdt.reporting_pdt_id, khr.start_date
FROM okl_k_headers_full_v khr, okl_products pdt
WHERE khr.id = l_khr_id
AND khr.pdt_id = pdt.id;
SELECT DEPENDENT_STY_ID
FROM OKL_STRM_TMPT_LINES_UV STL
WHERE PRIMARY_YN = 'N'
AND STL.PDT_ID = l_product_id
AND (STL.START_DATE <= l_contract_start_date)
AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND PRIMARY_STY_PURPOSE = p_primary_sty_purpose
AND DEPENDENT_STY_PURPOSE = p_dependent_sty_purpose;
SELECT pdt.reporting_pdt_id, khr.start_date
FROM okl_k_headers_full_v khr, okl_products pdt
WHERE khr.id = l_khr_id
AND khr.pdt_id = pdt.id;
SELECT DEPENDENT_STY_ID
FROM OKL_STRM_TMPT_LINES_UV STL
WHERE PRIMARY_YN = 'N'
AND STL.PDT_ID = l_product_id
AND (STL.START_DATE <= l_contract_start_date)
AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND PRIMARY_STY_ID = p_primary_sty_id
AND DEPENDENT_STY_PURPOSE = p_dependent_sty_purpose;
SELECT pdt.reporting_pdt_id, khr.start_date
FROM okl_k_headers_full_v khr, okl_products pdt
WHERE khr.id = l_khr_id
AND khr.pdt_id = pdt.id;
SELECT DEPENDENT_STY_ID
FROM OKL_STRM_TMPT_LINES_UV STL
WHERE PRIMARY_YN = 'N'
AND STL.PDT_ID = l_product_id
AND (STL.START_DATE <= l_contract_start_date)
AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND PRIMARY_STY_PURPOSE = p_primary_sty_purpose
AND DEPENDENT_STY_PURPOSE = p_dependent_sty_purpose;
SELECT pdt_id, start_date
FROM okl_k_headers_full_v
WHERE id = l_khr_id;
SELECT '1'
FROM OKL_STRM_TMPT_FULL_UV STL
WHERE STL.PDT_ID = l_product_id
AND (STL.START_DATE <= l_contract_start_date)
AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
AND STY_ID = p_sty_id;
SELECT sis_code, log_file FROM okl_stream_interfaces
WHERE transaction_number = trx_number;
SELECT
gts.pricing_engine
FROM
okl_k_headers khr,
okl_products_v pdt,
okl_ae_tmpt_sets_v aes,
OKL_ST_GEN_TMPT_SETS gts
WHERE
khr.pdt_id = pdt.id AND
pdt.aes_id = aes.id AND
aes.gts_id = gts.id AND
khr.id = p_khr_id;
SELECT
gts.name
FROM
okl_k_headers khr,
okl_products_v pdt,
okl_ae_tmpt_sets_v aes,
OKL_ST_GEN_TMPT_SETS gts
WHERE
khr.pdt_id = pdt.id AND
pdt.aes_id = aes.id AND
aes.gts_id = gts.id AND
khr.id = p_khr_id;
SELECT PRECISION
FROM fnd_currencies_vl
WHERE currency_code = p_currency_code
AND enabled_flag = 'Y'
AND NVL(start_date_active, SYSDATE) <= SYSDATE
AND NVL(end_date_active, SYSDATE) >= SYSDATE;
SELECT b.stm_apply_rounding_difference
FROM fnd_lookups a,
OKL_SYS_ACCT_OPTS b
WHERE a.lookup_type = p_lookup_type
AND a.lookup_code = b.stm_apply_rounding_difference;
SELECT authoring_org_id,
currency_code
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT stm_rounding_rule
FROM OKL_SYS_ACCT_OPTS;
SELECT authoring_org_id,
currency_code
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT PRECISION
FROM fnd_currencies_vl
WHERE currency_code = p_currency_code
AND enabled_flag = 'Y'
AND NVL(start_date_active, SYSDATE) <= SYSDATE
AND NVL(end_date_active, SYSDATE) >= SYSDATE;
SELECT stm_rounding_rule
FROM OKL_SYS_ACCT_OPTS;
SELECT b.stm_apply_rounding_difference
FROM fnd_lookups a,
OKL_SYS_ACCT_OPTS b
WHERE a.lookup_type = p_lookup_type
AND a.lookup_code = b.stm_apply_rounding_difference;
SELECT SILB.KLE_ID
FROM OKL_SIF_RET_LEVELS SRLB,
OKL_SIF_RETS SIRB,
OKL_STREAM_INTERFACES SIFB,
OKL_SIF_LINES SILB
WHERE SIFB.TRANSACTION_NUMBER = p_trx_number
AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER
AND SILB.SIF_ID = SIFB.ID
AND SRLB.SIR_ID = SIRB.ID
AND SRLB.INDEX_NUMBER = SILB.INDEX_NUMBER
AND SRLB.INDEX_NUMBER = p_index_number;