APPS.AR_ARZCARPO_XMLP_PKG SQL Statements

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

Line: 18

	 SELECT SUBSTR(ARGUMENT1,INSTR(ARGUMENT1,'=')+1,LENGTH(ARGUMENT1)),
	SUBSTR(ARGUMENT2,INSTR(ARGUMENT2,'=')+1,LENGTH(ARGUMENT2)),
	SUBSTR(ARGUMENT3,INSTR(ARGUMENT3,'=')+1,LENGTH(ARGUMENT3)),
	SUBSTR(ARGUMENT4,INSTR(ARGUMENT4,'=')+1,LENGTH(ARGUMENT4)),
	SUBSTR(ARGUMENT5,INSTR(ARGUMENT5,'=')+1,LENGTH(ARGUMENT5)),
	SUBSTR(ARGUMENT6,INSTR(ARGUMENT6,'=')+1,LENGTH(ARGUMENT6))
	INTO P_PROCESS_TYPE,P_BATCH_ID,P_CREATE_FLAG,P_APPROVE_FLAG,P_FORMAT_FLAG,P_REQUEST_ID_MAIN
	FROM FND_CONCURRENT_REQUESTS WHERE REQUEST_ID=P_CONC_REQUEST_ID;

Line: 27

      SELECT
        NAME
      INTO P_BATCH_NAME
      FROM
        AR_BATCHES
      WHERE BATCH_ID = P_BATCH_ID;