APPS.AR_ARXAPIPM_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: 188

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

Line: 207

  SELECT meaning
  INTO   l_summarize
  FROM   FND_LOOKUPS
  WHERE  lookup_code = P_SUMMARIZE
  AND    lookup_type = 'YES_NO';

Line: 226

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