APPS.OKL_BILLING_REF_WF SQL Statements

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

Line: 20

    SELECT okl_wf_item_s.nextval
    FROM  dual;

Line: 37

    l_parameter_list.DELETE;

Line: 81

      SELECT trx.request_number,trx.amount,trx.created_by,request_reason_code -- Bug 3983938
      FROM okl_trx_requests trx
      WHERE trx.id = p_request_id;

Line: 87

      SELECT meaning
      FROM  fnd_lookups frr
      WHERE frr.lookup_code = p_reason_code
      AND   lookup_type = 'OKL_REFUND_REASON';

Line: 94

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

Line: 100

      SELECT HZP.party_name
      FROM HZ_PARTIES HZP,
           HZ_CUST_ACCOUNTS HZCA
      WHERE HZP.party_id =HZCA.PARTY_ID
      AND HZCA.CUST_ACCOUNT_ID =p_cust_acct_id;