The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT payment_method
FROM ozf_claims
WHERE claim_id = cv_claim_id;
SELECT payment_method
FROM ozf_claims
WHERE claim_id = cv_claim_id;
SELECT payment_method
FROM ozf_claims
WHERE claim_id = cv_claim_id;
SELECT payment_method
FROM ozf_claims
WHERE claim_id = cv_claim_id;
SELECT DECODE(MAX(gl.period_name), '', 0, 1)
FROM gl_period_statuses gl
, ozf_claims c
WHERE gl.application_id = cv_app_id
AND c.claim_id= cv_claim_id
AND gl.set_of_books_id = c.set_of_books_id
AND gl.adjustment_period_flag = 'N'
AND trunc(c.gl_date) BETWEEN gl.start_date AND gl.end_date
AND gl.closing_status IN ('O', 'F');
SELECT DECODE(MAX(gl.period_name), '', 0, 1)
FROM gl_period_statuses gl
, ozf_claims c
WHERE gl.application_id = cv_app_id
AND c.claim_id= cv_claim_id
AND gl.set_of_books_id = c.set_of_books_id
AND gl.adjustment_period_flag = 'N'
AND trunc(cv_gl_date) BETWEEN gl.start_date AND gl.end_date
AND gl.closing_status IN ('O', 'F');
SELECT claim_line_id
, currency_code
, amount
, claim_currency_amount
, acctd_amount
, earnings_associated_flag
, performance_complete_flag
, source_object_class
, source_object_id
, source_object_line_id
, item_id
FROM ozf_claim_lines
WHERE claim_id = cv_claim_id
AND claim_currency_amount <> 0;
SELECT op.offer_performance_id
FROM ozf_claim_lines_util lu
, ozf_funds_utilized fu
, ozf_offer_performances op
WHERE lu.utilization_id = fu.utilization_id
AND fu.component_type = 'OFFR'
AND fu.component_id = op.list_header_id
AND (op.requirement_type IS NULL OR op.requirement_type NOT IN ('AMOUNT', 'VOLUME'))
AND op.required_flag = 'Y'
AND lu.claim_line_id = cv_claim_line_id;
SELECT op.offer_performance_id
FROM ozf_claim_lines ln
, ozf_offer_performances op
WHERE ln.activity_type = 'OFFR'
AND ln.activity_id = op.list_header_id
AND (op.requirement_type IS NULL OR op.requirement_type NOT IN ('AMOUNT', 'VOLUME'))
AND op.required_flag = 'Y'
AND ln.claim_line_id = cv_claim_line_id;
SELECT NVL(SUM(amount), 0)
FROM ozf_claim_lines_util
WHERE claim_line_id = cv_claim_line_id;
SELECT NVL(SUM(claim_currency_amount), 0)
FROM ozf_claim_lines
WHERE claim_id = cv_claim_id;
SELECT NVL(SUM(claim_currency_amount), 0),NVL(SUM(claim_curr_tax_amount), 0)
FROM ozf_claim_lines
WHERE claim_id = cv_claim_id;
SELECT distinct earnings_associated_flag
FROM ozf_claim_lines
WHERE claim_id = cv_claim_id
AND claim_currency_amount <> 0;
SELECT DECODE(MAX(period_name), '', 0, 1)
FROM gl_period_statuses
WHERE application_id = cv_app_id
AND set_of_books_id = cv_set_of_books_id
AND adjustment_period_flag = 'N'
AND SYSDATE BETWEEN start_date AND end_date
AND closing_status IN ('O', 'F');
SELECT post_to_gl
, payables_source
, batch_source_id
, gl_id_ded_clearing
, gl_rec_clearing_account
, gl_date_type
FROM ozf_sys_parameters;
SELECT inventory_item_id
, uom_code
, quantity_invoiced
FROM ra_customer_trx_lines
WHERE customer_trx_line_id = cv_invoice_line_id;
SELECT customer_trx_line_id
FROM ra_customer_trx_lines
WHERE customer_trx_id = cv_invoice_id
AND customer_trx_line_id = cv_invoice_line_id;
SELECT ocs.seeded_flag
FROM ozf_claim_sttlmnt_methods_all ocs,
ozf_claims_all oc
WHERE claim_id = cv_claim_id
AND ocs.claim_class = oc.claim_class
AND NVL(ocs.source_object_class,'NULL') = NVL(oc.source_object_class,'NULL')
AND ocs.settlement_method = oc.payment_method ;
SELECT gl_date_type
FROM ozf_sys_parameters
WHERE set_of_books_id = cv_set_of_books_id;
SELECT 1 FROM po_vendors pv, po_vendor_sites pvs
WHERE pv.vendor_id = pvs.vendor_id
AND (sysdate between nvl(pv.start_date_active, sysdate-1) and nvl(pv.end_date_active, sysdate+1))
AND (pvs.inactive_date is null or pvs.inactive_date > trunc(sysdate))
AND pv.vendor_id = cv_vendor_id
AND pvs.vendor_site_id = cv_vendor_site_id;