APPS.AR_ARXFXGL_XMLP_PKG SQL Statements

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

Line: 84

          SELECT CUST.ACCOUNT_NUMBER,
                 SUBSTRB(PARTY.PARTY_NAME,1,50)
          INTO   P_Customer_Number,
                 P_Customer_Name
          FROM   HZ_CUST_ACCOUNTS CUST,
		 HZ_PARTIES PARTY
          WHERE  CUST.CUST_ACCOUNT_ID = P_Customer_Id
	  AND    CUST.PARTY_ID = PARTY.PARTY_ID;

Line: 118

          SELECT location
          INTO   P_Location
          FROM   HZ_CUST_site_uses_all
          WHERE  site_use_id = P_site_use_id;

Line: 144

          SELECT user_conversion_type
          INTO   P_Exchange_Rate_Type
          FROM   gl_daily_conversion_types
          WHERE  conversion_type = P_Rate_Type;

Line: 351

     SELECT cp.user_concurrent_program_name
     INTO   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: 376

     SELECT cur.currency_code,
            cur.precision,
            sob.name
     INTO   Functional_Currency,
            Functional_Precision,
            Set_Of_Books_Name
     FROM   fnd_currencies cur,
            gl_sets_of_books sob
     WHERE  cur.currency_code = sob.currency_code
     AND    sob.set_of_books_id = P_Set_Of_Books_Id;