DBA Data[Home] [Help]

APPS.OKL_BILLING_CORR_REQ_WF SQL Statements

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

Line: 19

    SELECT okl_wf_item_s.nextval
    FROM  dual;
Line: 36

    l_parameter_list.DELETE;
Line: 68

      SELECT trx.request_number
      FROM okl_trx_requests trx
      WHERE trx.id = p_request_id;
Line: 73

      SELECT chrv.contract_number
      FROM okc_k_headers_v chrv
      WHERE chrv.id = p_contract_id;