APPS.AR_RAXINVPR_XMLP_PKG SQL Statements

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

Line: 65

arp_trx_select_control.build_where_clause(
 p_choice, p_open_invoice, p_cust_trx_type_id,
 p_cust_trx_class,
 p_installment_number, p_dates_low, p_dates_high,
 p_customer_id, p_customer_class_code, p_trx_number_low,
 p_trx_number_high, p_batch_id, p_customer_trx_id,
 p_adj_number_low, p_adj_number_high,
 p_adj_dates_low, p_adj_dates_high,
 where1, where2, table1, table2 );

Line: 107

select  option_lu.meaning
--into    print_option
into    print_option_t
from    ar_lookups              option_lu
where   option_lu.lookup_type(+) = 'INVOICE_PRINTING'
and     option_lu.lookup_code(+) = upper(p_choice);

Line: 120

	select  name
	--into    type_id
	into    type_id_t
	from    ra_cust_trx_types
	where   cust_trx_type_id = p_customer_trx_id;

Line: 132

	select  substrb(party.party_name,1,50)
	--into    customer_id
	into    customer_id_t
	from    hz_cust_accounts           cust,
		hz_parties		party
	where   cust.cust_account_id  = p_customer_id
          and   cust.party_id = party.party_id;

Line: 148

	select  bat.name
	--into    batch_id
	into    batch_id_t
	from    ra_batches              bat
	where   bat.batch_id = p_batch_id;

Line: 160

	select  open_lu.meaning
	--into    open_invoices
	into    open_invoices_t
	from    ar_lookups              open_lu
	where   open_lu.lookup_type = 'YES/NO'
	and     open_lu.lookup_code = p_open_invoice;

Line: 192

        SELECT sob.name   Company_Name,
               sob.currency_code Functional_Currency
	--INTO   company_name, functional_currency
	INTO   company_name, functional_currency_t
	FROM    gl_sets_of_books sob, ar_system_parameters ar
	WHERE   sob.set_of_books_id  = ar.set_of_books_id;

Line: 203

    SELECT cp.user_concurrent_program_name
    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;