APPS.AR_ARHLERPT_XMLP_PKG SQL Statements

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

Line: 5

    SELECT
      BATCH_NAME,
      ORIGINAL_SYSTEM,
      TRUNC(CREATION_DATE),
      LOAD_TYPE,
      TOTAL_BATCH_RECORDS,
      TOTAL_RECORDS_IMPORTED
    INTO P_BATCH_NAME,P_ORIG_SYS,P_CRE_DT,P_LOAD_TYPE,P_TOT_B_REC,P_TOT_REC_IMP
    FROM
      HZ_IMP_BATCH_SUMMARY
    WHERE BATCH_ID = P_BATCH_ID;