APPS.AR_RAXCUS_XMLP_PKG SQL Statements

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

Line: 25

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

select  decode(upper(p_status_low),  NULL, min(look.lookup_code),
					   p_status_low),
	decode(upper(p_status_high), NULL, max(look.lookup_code),
					   p_status_high),
	decode(upper(p_customer_name_low),    NULL, min(substrb(party.party_name,1,50)),
				    	   p_customer_name_low),
	decode(upper(p_customer_name_high),   NULL, max(substrb(party.party_name,1,50)),
				    	   p_customer_name_high),
	decode(upper(p_customer_number_low), NULL, min(c.account_number),
		     		      	     p_customer_number_low),
	decode(upper(p_customer_number_high),NULL, max(c.account_number),
				      	     p_customer_number_high)
into 	l_status_low,
	l_status_high,
	l_customer_name_low,
	l_customer_name_high,
	l_customer_number_low,
	l_customer_number_high
from 	hz_cust_accounts c,
	hz_parties party,
	ar_lookups look
where	c.status = look.lookup_code
   and  c.party_id = party.party_id
        and    look.lookup_type = 'CODE_STATUS';