APPS.GMO_PURGE dependencies on GMO_INSTR_TASK_INSTANCE_T

Line 86: execute immediate 'truncate table GMO_INSTR_TASK_INSTANCE_T';

82: execute immediate 'truncate table GMO_INSTR_APPR_DEFN_T';
83: execute immediate 'truncate table GMO_INSTR_DEFN_T';
84: execute immediate 'truncate table GMO_INSTR_SET_DEFN_T';
85: /* Truncate Instance temporary tables */
86: execute immediate 'truncate table GMO_INSTR_TASK_INSTANCE_T';
87: execute immediate 'truncate table GMO_INSTR_EREC_INSTANCE_T';
88: execute immediate 'truncate table GMO_INSTR_INSTANCE_T';
89: execute immediate 'truncate table GMO_INSTR_SET_INSTANCE_T';
90: /* Truncate Attributes table in the end */

Line 101: delete GMO_INSTR_TASK_INSTANCE_T where LAST_UPDATE_DATE <= P_END_DATE;

97: delete GMO_INSTR_DEFN_T where LAST_UPDATE_DATE <= P_END_DATE;
98: delete GMO_INSTR_SET_DEFN_T where LAST_UPDATE_DATE <= P_END_DATE;
99:
100: /* Truncate Instance temporary tables */
101: delete GMO_INSTR_TASK_INSTANCE_T where LAST_UPDATE_DATE <= P_END_DATE;
102: delete GMO_INSTR_EREC_INSTANCE_T where LAST_UPDATE_DATE <= P_END_DATE;
103: delete GMO_INSTR_INSTANCE_T where LAST_UPDATE_DATE <= P_END_DATE;
104: delete GMO_INSTR_SET_INSTANCE_T where LAST_UPDATE_DATE <= P_END_DATE;
105: