APPS.AR_ARXAPRMB_XMLP_PKG SQL Statements

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

Line: 12

    SELECT substr(cp.user_concurrent_program_name,1,80)
    INTO   l_report_name
    FROM   FND_CONCURRENT_PROGRAMS_VL cp,
           FND_CONCURRENT_REQUESTS cr
    WHERE  cr.request_id = P_CONC_REQUEST_ID
    AND    cp.application_id = cr.program_application_id
    AND    cp.concurrent_program_id = cr.concurrent_program_id;

Line: 78

  SELECT meaning
  INTO   l_sort_by
  FROM   AR_LOOKUPS
  WHERE  lookup_type = 'SORT_BY_ARXAPRMB'
  AND    lookup_code = P_SORT_BY;

Line: 97

  SELECT meaning
  INTO   l_status
  FROM   AR_LOOKUPS
  WHERE  lookup_type = 'BATCH_APPLIED_STATUS'
  AND    lookup_code = P_STATUS;

Line: 120

      SELECT sum(nvl(cr.amount,0)+nvl(cr.factor_discount_amount,0))
      INTO   l_amount
      FROM   ar_cash_receipts cr
      WHERE  cr.selected_remittance_batch_id = p_batch_id;

Line: 129

      SELECT sum(nvl(crh.amount,0)+nvl(crh.factor_discount_amount,0))
      INTO   l_amount
      FROM   ar_cash_receipt_history crh,
             ar_cash_receipt_history crhprv
      WHERE  crh.batch_id = p_batch_id
      AND    crh.cash_receipt_history_id =
               crhprv.reversal_cash_receipt_hist_id
      AND    crhprv.status = 'CONFIRMED'
      AND    crh.status    = 'REMITTED';

Line: 151

  SELECT meaning
  INTO   l_rem_met
  FROM   AR_LOOKUPS
WHERE LOOKUP_TYPE = 'REMITTANCE_METHOD'
 AND   ENABLED_FLAG = 'Y'
AND LOOKUP_CODE = P_REMITTANCE_METHOD;

Line: 172

  SELECT BANK_ACCOUNT_NAME
  INTO   l_rem_acc
  FROM   CE_BANK_ACCOUNTS  cba,
         ce_bank_acct_uses  ba
WHERE BANK_ACCT_USE_ID =P_REMIT_BANK_ACCOUNT
AND     cba.bank_account_id = ba.bank_account_id;

Line: 193

  SELECT meaning
  INTO   l_inc_form
  FROM   FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
 AND   ENABLED_FLAG = 'Y'
AND LOOKUP_CODE = P_INCLUDE_FORMATTED;

Line: 214

  SELECT meaning
  INTO   l_sum_or_det
  FROM   AR_LOOKUPS
WHERE LOOKUP_TYPE = 'ARXAPRMB_SD'
 AND   ENABLED_FLAG = 'Y'
AND LOOKUP_CODE = P_SUMMARY_OR_DETAILED;