APPS.GMO_PURGE dependencies on GMO_INSTR_APPR_DEFN_T

Line 82: execute immediate 'truncate table GMO_INSTR_APPR_DEFN_T';

78: END IF ;
79:
80: IF(P_TRUNCATE_TABLE = GMO_CONSTANTS_GRP.YES) THEN
81: /* Truncate Definition temporary tables */
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';

Line 96: delete GMO_INSTR_APPR_DEFN_T where LAST_UPDATE_DATE <= P_END_DATE;

92: RETURN;
93: END IF;
94:
95: /* Delete Definition temporary tables */
96: delete GMO_INSTR_APPR_DEFN_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 */