APPS.AR_ARXRJR_XMLP_PKG SQL Statements

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

Line: 38

select set_of_books_id into h_sob_id from ar_system_parameters_all
where org_id  = p_reporting_context;

Line: 67

    select replace(p_cr_where,':p_reporting_entity_id',p_reporting_context),
     replace(p_cust_where,':p_reporting_entity_id',p_reporting_context),
     replace(p_site_where,':p_reporting_entity_id',p_reporting_context)
    into p_cr_where,p_cust_where,p_site_where from dual;

Line: 74

      select substrb(meaning,1,10) into reporting_context_name from ar_lookups
      where lookup_code='ALL' and lookup_type='ALL';

Line: 90

SELECT sob.name, nvl(p_currency, sob.currency_code)
INTO   p_company_name, p_currency_disp
FROM    gl_sets_of_books sob
WHERE   sob.set_of_books_id  = h_sob_id;

Line: 99

      select replace(lp_customer_name_low,':p_in_customer_name_low',p_in_customer_name_low)
        into lp_customer_name_low from dual;

Line: 105

      select replace(lp_customer_name_high,':p_in_customer_name_high',p_in_customer_name_high)
        into lp_customer_name_high from dual;

Line: 112

        select replace(lp_customer_num_low,':p_in_customer_num_low',p_in_customer_num_low)
        into lp_customer_num_low from dual;

Line: 118

      select replace(lp_customer_num_high,':p_in_customer_num_high',p_in_customer_num_high)
       into lp_customer_num_high from dual;