APPS.OKL_PAYMENT_PVT SQL Statements

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

Line: 44

      SELECT authoring_org_id
      FROM   okc_k_headers_b
      WHERE  id = p_contract_id;

Line: 107

    SELECT  1
    FROM   ar_receipt_methods
    WHERE  receipt_method_id = p_payment_method_id;

Line: 116

 select UPPER(currency_conversion_type),
        currency_conversion_rate,
        currency_conversion_date
 from okl_k_headers
 where id =p_contract_id;

Line: 321

    SELECT  1
    FROM   ar_receipt_methods
    WHERE  receipt_method_id = p_payment_method_id;

Line: 327

select upper(chr.currency_conversion_type),
        chr.currency_conversion_rate,
        chr.currency_conversion_date
 from okl_k_headers chr,
      okl_cnsld_ar_lines_b lln,
      okl_cnsld_ar_strms_b strm
 where strm.khr_id =chr.id
 and  lln.cnr_id  =p_invoice_id
 and  strm.lln_id =lln.id
 and rownum <2
 group by chr.currency_conversion_type,
        chr.currency_conversion_rate,
        chr.currency_conversion_date
Order by chr.currency_conversion_type;

Line: 563

	 Select Trx_date apply_date
	 from ra_customer_trx_all
	 where customer_trx_id=l_customer_trx_id
	 and org_id=l_orgid;

Line: 576

  SELECT ID INTO l_rct_id
  FROM   OKL_TRX_CSH_RECEIPT_V
  WHERE  AMOUNT = cp_amount
  AND    IBA_ID = cp_bank_acct_id
  AND    ILE_ID = cp_cust_id
  AND    DATE_EFFECTIVE = cp_rcpt_date
  AND    IRM_ID = cp_irm_id
  ORDER BY CREATION_DATE DESC;

Line: 586

  SELECT ORG_ID
  FROM   RA_CUSTOMER_TRX_ALL
  WHERE  CUSTOMER_TRX_ID = ar_inv_id;

Line: 591

  SELECT ORG_ID
  FROM   OKL_CNSLD_AR_HDRS_ALL_B
  WHERE  ID = cons_inv_id;

Line: 596

  SELECT receipt_method_id
  FROM   okl_pmt_channel_methods_All
  WHERE  ORG_ID = p_org_id
  AND    payment_channel_code = cp_payment_channel_code;

Line: 602

  SELECT bank_account_id
  FROM   okl_bpd_rcpt_mthds_uv
  WHERE  ORG_ID = cp_org_id
  AND    RECEIPT_METHOD_ID = cp_irm_id;

Line: 608

  SELECT PAYMENT_CHANNEL_CODE
  FROM IBY_FNDCPT_TX_EXTENSIONS
  WHERE TRXN_EXTENSION_ID = cp_trx_extn_id;

Line: 616

  SELECT ID, ICR_ID
  FROM   OKL_EXT_CSH_RCPTS_V
  WHERE  RCT_ID = cp_rct_id;