152: FND_GLOBAL.prog_appl_id,
153: FND_GLOBAL.conc_program_id,
154: SYSDATE
155: FROM ego_massupdate_item_tmp emit,
156: ego_massupdate_org_tmp emot,
157: mtl_parameters mp
158: WHERE NOT EXISTS
159: (SELECT '1'
160: FROM mtl_system_items_b msib
347: DELETE ego_massupdate_item_tmp where to_date(to_char (creation_date,'hh24:mi:ss
348: dd-mm-yyyy'),'hh24:mi:ss dd-mm-yyyy') < to_date(to_char (sysdate-hours/24,'hh24:mi:ss
349: dd-mm-yyyy'),'hh24:mi:ss dd-mm-yyyy');
350:
351: DELETE ego_massupdate_org_tmp where to_date(to_char (creation_date,'hh24:mi:ss
352: dd-mm-yyyy'),'hh24:mi:ss dd-mm-yyyy') < to_date(to_char (sysdate-hours/24,'hh24:mi:ss
353: dd-mm-yyyy'),'hh24:mi:ss dd-mm-yyyy');
354:
355: COMMIT;