The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT distinct(consolidated_invoice_number), due_date
FROM okl_rcpt_consinv_balances_uv
WHERE customer_number = cp_cust_num
AND org_id= cp_org_id
ORDER BY due_date;
SELECT distinct(contract_number)
FROM okl_rcpt_cust_cont_balances_uv
WHERE customer_number = cp_cust_num
AND org_id= cp_org_id
ORDER BY invoice_due_date;
SELECT distinct(invoice_number), invoice_due_date due_date
FROM okl_rcpt_arinv_balances_uv
WHERE customer_number = cp_cust_num
AND org_id= cp_org_id
ORDER BY invoice_due_date;
SELECT AR_INVOICE_ID,
AR_INVOICE_NUMBER,
AR_INVOICE_LINE_ID INVOICE_LINE_ID,
LINE_NUMBER,
AMOUNT_DUE_REMAINING,
CURRENCY_CODE
FROM okl_rcpt_consinv_balances_uv lpt
WHERE lpt.consolidated_invoice_number = cp_cons_bill_num
AND lpt.customer_number = NVL (cp_customer_num, lpt.customer_number)
AND lpt.stream_type_id = NVL (cp_stream_type_id, lpt.stream_type_id)
AND lpt.amount_due_remaining > 0
AND lpt.org_id=cp_org_id
AND lpt.status='OP';
Select AR_INVOICE_ID Ar_Invoice_Id,
Invoice_Number AR_INVOICE_NUMBER,
INVOICE_LINE_ID invoice_line_id,
Line_Identifier Line_Number,
amount_due_remaining amount_due_remaining,
invoice_currency_code CURRENCY_CODE
From OKL_RCPT_ARINV_BALANCES_UV
Where Invoice_Number = cp_ar_bill_num
And Org_id = cp_org_id
AND amount_due_remaining > 0
AND status = 'OP'
And sty_Id = Nvl(cp_stream_type_id,sty_id);
SELECT AR_INVOICE_ID,
AR_INVOICE_NUMBER,
INVOICE_LINE_ID,
LINE_NUMBER,
AMOUNT_DUE_REMAINING,
CURRENCY_CODE
FROM OKL_RCPT_CUST_CONT_BALANCES_UV
WHERE CONTRACT_NUMBER = NVL (cp_contract_num, CONTRACT_NUMBER)
AND STY_ID = NVL(cp_stream_type_id, STY_ID)
AND CUSTOMER_ACCOUNT_NUMBER = cp_customer_num
AND ORG_ID = cp_org_id
AND STATUS = 'OP'
AND AMOUNT_DUE_REMAINING > 0;
SELECT id, sequence_number, cash_search_type
FROM okl_csh_allct_srchs
ORDER BY sequence_number;
SELECT sty_id, add_yn
FROM okl_srch_strm_typs
WHERE cah_id = cp_cah_id;