APPS.AR_RAXSOL_XMLP_PKG SQL Statements

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

Line: 31

    SELECT substrb(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: 56

  select meaning
	into l_id
	from ar_lookups
	where lookup_type = 'REFERENCE'
	and   lookup_code = 'Id';

Line: 72

  select meaning
	into l_none
	from ar_lookups
	where lookup_type = 'REFERENCE'
	and   lookup_code = 'None';

Line: 88

  select meaning
	into l_number
	from ar_lookups
	where lookup_type = 'REFERENCE'
	and   lookup_code = 'Number';

Line: 105

  select meaning
	into l_segment
	from ar_lookups
	where lookup_type = 'REFERENCE'
	and   lookup_code = 'Segment';

Line: 122

  select meaning
	into l_value
	from ar_lookups
	where lookup_type = 'REFERENCE'
	and   lookup_code = 'Value';

Line: 138

  select meaning
	into l_yes
	from ar_lookups
	where lookup_type = 'YES/NO'
	and   lookup_code = 'Y';

Line: 154

  select meaning
	into l_no
	from ar_lookups
	where lookup_type = 'YES/NO'
	and   lookup_code = 'N';

Line: 169

  select meaning
	into l_amt
	from ar_lookups
	where lookup_type = 'AMT/PER'
	and   lookup_code = 'Amount';

Line: 184

  select meaning
	into l_per
	from ar_lookups
	where lookup_type = 'AMT/PER'
	and   lookup_code = 'Percent';

Line: 199

  select meaning
	into l_code
	from ar_lookups
	where lookup_type = 'CODE'
	and   lookup_code = 'Code';

Line: 226

   SELECT MAX(TRX_NUMBER)
        INTO   l_last_invoice_number
        FROM   RA_CUSTOMER_TRX
        WHERE  BATCH_SOURCE_ID = batch_source_id_t
    ;

Line: 245

  SELECT SYSDATE
         INTO l_date
         FROM
         DUAL ;

Line: 271

select meaning
  into w_meaning
  from fnd_lookups
 where lookup_type = p_lookup_type
   and lookup_code = p_lookup_code ;