APPS.OKL_STREAM_BILLING_PUB SQL Statements

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

Line: 108

            DELETE OKL_PARALLEL_PROCESSES
            WHERE assigned_process = p_assigned_process;

Line: 123

            DELETE OKL_PARALLEL_PROCESSES
            WHERE assigned_process = p_assigned_process;

Line: 138

            DELETE OKL_PARALLEL_PROCESSES
            WHERE assigned_process = p_assigned_process;

Line: 185

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

Line: 190

          SELECT count(*)
          FROM okl_trx_ar_invoices_v a,
               okl_txl_ar_inv_lns_v b,
               okl_txd_ar_ln_dtls_v c
          WHERE a.id = b.tai_id AND
                b.id = c.til_id_details AND
                a.trx_status_code = 'PROCESSED' AND
                a.request_id = p_req_id ;

Line: 200

          SELECT count(*)
          FROM okl_trx_ar_invoices_v a,
               okl_txl_ar_inv_lns_v b,
               okl_txd_ar_ln_dtls_v c
          WHERE a.id = b.tai_id AND
                b.id = c.til_id_details AND
                a.trx_status_code = 'ERROR' AND
                a.request_id = p_req_id ;

Line: 213

           SELECT NAME
           FROM hr_operating_units
	   WHERE ORGANIZATION_ID=MO_GLOBAL.GET_CURRENT_ORG_ID;--MOAC- Concurrent request

Line: 283

            DELETE OKL_PARALLEL_PROCESSES
            WHERE assigned_process = p_assigned_process;