APPS.AR_RAXINPS_XMLP_PKG SQL Statements

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

Line: 64

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

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

Line: 138

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