APPS.AR_ARXCCP_XMLP_PKG SQL Statements

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

Line: 7

    	 EXECUTE IMMEDIATE 'SELECT meaning
				            FROM ar_lookups
				            WHERE lookup_type = ''YES/NO''
				            AND lookup_code = ''Y'''
				            INTO NLS_YES ;

Line: 13

/*SRW.DO_SQL('SELECT meaning
            INTO :NLS_YES
            FROM ar_lookups
            WHERE lookup_type = ''YES/NO''
            AND lookup_code = ''Y''');*/null;

Line: 37

	 EXECUTE IMMEDIATE 'SELECT meaning
			            FROM ar_lookups
			            WHERE lookup_type = ''YES/NO''
			            AND lookup_code = ''N'''
			            INTO nls_no ;

Line: 43

/*SRW.DO_SQL('SELECT meaning
            INTO :nls_no
            FROM ar_lookups
            WHERE lookup_type = ''YES/NO''
            AND lookup_code = ''N''');*/null;

Line: 94

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