DBA Data[Home] [Help]

APPS.CZ_PUB_MGR dependencies on CZ_PB_MODEL_EXPORTS

Line 306: from cz_pb_model_exports

302: -- server_id / model_id
303: --
304: for i in(select server_id,model_id,
305: max(export_id) as max_export_id
306: from cz_pb_model_exports
307: where status='OK'
308: group by server_id,model_id)
309: loop
310: delete from cz_pb_model_exports

Line 310: delete from cz_pb_model_exports

306: from cz_pb_model_exports
307: where status='OK'
308: group by server_id,model_id)
309: loop
310: delete from cz_pb_model_exports
311: where export_id<>i.max_export_id and model_id=i.model_id and
312: server_id=i.server_id;
313: end loop;
314: commit;