The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT rct.bill_to_customer_id
FROM hz_cust_accounts bill_to_cust,
hz_parties party,
ra_customer_trx rct
WHERE rct.bill_to_customer_id = bill_to_cust.cust_account_id
AND bill_to_cust.party_id = party.party_id
AND rct.customer_trx_id =
(SELECT r.customer_trx_id
FROM ar_lookups l, ra_cm_requests r
WHERE r.request_id = p_txn_id
AND r.cm_reason_code = l.lookup_code
AND l.lookup_type = 'CREDIT_MEMO_REASON');
SELECT r.customer_trx_id
FROM ar_lookups l,
ra_cm_requests r
WHERE r.request_id = p_txn_id
AND r.cm_reason_code = l.lookup_code
AND l.lookup_type = 'CREDIT_MEMO_REASON';
SELECT rct.bill_to_site_use_id
FROM hz_cust_accounts bill_to_cust,
hz_parties party,
ra_customer_trx rct
WHERE rct.bill_to_customer_id = bill_to_cust.cust_account_id
AND bill_to_cust.party_id = party.party_id
AND rct.customer_trx_id =
(SELECT r.customer_trx_id
FROM ar_lookups l,ra_cm_requests r
WHERE r.request_id = p_txn_id
AND r.cm_reason_code = l.lookup_code
AND l.lookup_type = 'CREDIT_MEMO_REASON');
SELECT 'person_id:' || col.employee_id, cp.site_use_id
FROM ar_collectors col,
hz_customer_profiles cp
WHERE cp.collector_id = col.collector_id
AND cp.cust_account_id = p_customer_id
AND (cp.site_use_id = p_bill_to_use_id
OR cp.site_use_id is NULL)
ORDER by cp.site_use_id;
SELECT tt.name
FROM ar_lookups l,
ra_cm_requests r,
ra_customer_trx t,
ra_cust_trx_types tt
WHERE r.request_id = p_transaction_id
AND r.cm_reason_code = l.lookup_code
AND l.lookup_type = 'CREDIT_MEMO_REASON'
AND t.customer_trx_id = r.customer_trx_id
AND t.cust_trx_type_id = tt.cust_trx_type_id;
SELECT interface_line_context
FROM ar_lookups l,
ra_cm_requests r,
ra_customer_trx_lines tl
WHERE r.request_id = p_transaction_id
AND r.cm_reason_code = l.lookup_code
AND l.lookup_type = 'CREDIT_MEMO_REASON'
AND tl.customer_trx_id = r.customer_trx_id
AND tl.interface_line_context IS NOT NULL
AND rownum = 1;