APPS.AR_ARXPAR_XMLP_PKG SQL Statements

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

Line: 24

    SELECT substrb(cp.user_concurrent_program_name,1,80)
    INTO   l_report_name
    FROM   FND_CONCURRENT_PROGRAMS_VL cp,
           FND_CONCURRENT_REQUESTS cr
    WHERE  cp.application_id = cr.program_application_id
    AND    cr.request_id = p_conc_request_id
    AND    cp.concurrent_program_id = cr.concurrent_program_id;

Line: 47

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

Line: 65

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