APPS.OKL_INVESTOR_INVOICE_DISB_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 94

	  SELECT
          DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)
	  FROM dual;

Line: 99

          SELECT count(*)
          FROM okl_trx_ap_invoices_v a,
               okl_txl_ap_inv_lns_v b
          WHERE a.id = b.tap_id AND
                a.trx_status_code = 'ENTERED' AND
                a.request_id = p_req_id ;

Line: 107

          SELECT count(*)
          FROM okl_trx_ap_invoices_v a,
               okl_txl_ap_inv_lns_v b
          WHERE a.id = b.tap_id AND
                a.trx_status_code = 'ERROR' AND
                a.request_id = p_req_id ;