APPS.AR_ARXCTA_XMLP_PKG SQL Statements

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

Line: 51

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

   select meaning
   into b
   from ar_lookups
   where lookup_type = 'SORT_BY_ARXCTA'
   and upper(lookup_code) = upper(p_order_by);