APPS.GMO_PURGE SQL Statements

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

Line: 33

     DELETE GMO_DEVICE_RESPONSES_T
     WHERE REQUEST_ID IN
         (SELECT REQUEST_ID
            FROM GMO_DEVICE_REQUESTS_T
           WHERE CREATION_DATE <= P_END_DATE );

Line: 39

        DELETE FROM GMO_DEVICE_REQUESTS_T WHERE CREATION_DATE <= P_END_DATE;

Line: 95

      /* Delete Definition temporary tables */
    delete GMO_INSTR_APPR_DEFN_T where LAST_UPDATE_DATE <= P_END_DATE;

Line: 97

    delete GMO_INSTR_DEFN_T where LAST_UPDATE_DATE <= P_END_DATE;

Line: 98

    delete GMO_INSTR_SET_DEFN_T where LAST_UPDATE_DATE <= P_END_DATE;

Line: 101

    delete GMO_INSTR_TASK_INSTANCE_T where LAST_UPDATE_DATE <= P_END_DATE;

Line: 102

    delete GMO_INSTR_EREC_INSTANCE_T where LAST_UPDATE_DATE <= P_END_DATE;

Line: 103

    delete GMO_INSTR_INSTANCE_T where LAST_UPDATE_DATE <= P_END_DATE;

Line: 104

    delete GMO_INSTR_SET_INSTANCE_T where LAST_UPDATE_DATE <= P_END_DATE;

Line: 107

    delete GMO_INSTR_ATTRIBUTES_T where LAST_UPDATE_DATE <= P_END_DATE;