APPS.AR_ARXAPRRM_XMLP_PKG SQL Statements

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

Line: 10

    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: 112

  SELECT meaning
  INTO   l_meaning
  FROM   FND_LOOKUPS
  WHERE  LOOKUP_TYPE = 'YES_NO'
  AND    LOOKUP_CODE = P_SUMMARIZE;

Line: 127

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

Line: 142

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

Line: 157

  SELECT meaning
  INTO   l_rmethod
  FROM   AR_LOOKUPS
  WHERE  lookup_type = 'REMITTANCE_METHOD'
  AND    lookup_code = P_REMIT_METHOD;