APPS.AR_ARXCBH_XMLP_PKG SQL Statements

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

Line: 28

    SELECT substr(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: 111

	SELECT MIN(name),
               MAX(name)
	INTO terms_name_low,
             terms_name_high
	FROM ra_terms;

Line: 174

select decode(app.amount_applied_from,NULL,NULL,'*') flag
from ar_receivable_applications app, ar_payment_schedules_all pay
where app.reversal_gl_date IS NULL
and app.applied_customer_trx_id (+) = pay.customer_trx_id
and pay.payment_schedule_id = p_payment_schedule_id;