DBA Data[Home] [Help]

APPS.AR_RAXIIR_XMLP_PKG SQL Statements

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

Line: 27

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

select min(account_number)
into l_min_customer_number
from hz_cust_accounts;
Line: 99

  SELECT
    MEANING
  INTO order_meaning
  FROM AR_LOOKUPS
  WHERE LOOKUP_TYPE = 'SORT_BY_RAXIIR'
        AND UPPER(LOOKUP_CODE) = UPPER(P_ORDER_BY);