DBA Data[Home] [Help]

APPS.CZ_PUB_MGR dependencies on CZ_PB_MODEL_EXPORTS

Line 281: from cz_pb_model_exports

277: -- server_id / model_id
278: --
279: for i in(select server_id,model_id,
280: max(export_id) as max_export_id
281: from cz_pb_model_exports
282: where status='OK'
283: group by server_id,model_id)
284: loop
285: delete from cz_pb_model_exports

Line 285: delete from cz_pb_model_exports

281: from cz_pb_model_exports
282: where status='OK'
283: group by server_id,model_id)
284: loop
285: delete from cz_pb_model_exports
286: where export_id<>i.max_export_id and model_id=i.model_id and
287: server_id=i.server_id;
288: end loop;
289: commit;