APPS.WIP_WIPPURGE_XMLP_PKG SQL Statements

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

Line: 17

                  MODE="SELECT" DISPLAY="ALL" TABLEALIAS="MSI" ')*/NULL;

Line: 21

 SELECT
      WIP_DATETIMES.LE_DATE_TO_SERVER(MAX(SCHEDULE_CLOSE_DATE)
                                     ,P_ORGANIZATION_ID)
    INTO P_MAX_DATE
    FROM
      ORG_ACCT_PERIODS
    WHERE PERIOD_CLOSE_DATE is not null
      AND OPEN_FLAG = 'N'
      AND ORGANIZATION_ID = TO_CHAR(P_ORGANIZATION_ID);

Line: 73

    DELETE FROM WIP_TEMP_REPORTS
     WHERE KEY1 = P_GROUP_ID_V;