APPS.CZ_UI_MGR dependencies on CZ_MODEL_PUBLICATIONS

Line 245: ------ in cz_model_publications

241: -----for deletion.
242: -----The published global templates that are candidates for
243: -----deletion have
244: ------ ui_def_id = 1 and have no valid entry (deleted_flag = '0')
245: ------ in cz_model_publications
246:
247:
248: l_pb_gl_template_tbl.DELETE;
249: SELECT template_id BULK COLLECT

Line 255: FROM cz_model_publications

251: FROM cz_ui_templates
252: WHERE cz_ui_templates.seeded_flag = '0'
253: AND cz_ui_templates.ui_def_id = 1
254: AND cz_ui_templates.template_id NOT IN (SELECT object_id
255: FROM cz_model_publications
256: WHERE object_type = 'UIT'
257: AND deleted_flag = '0'
258: AND ui_def_id = 1
259: AND source_target_flag = 'T');

Line 278: AND NOT EXISTS (SELECT 1 FROM cz_model_publications

274: SELECT jrad_doc BULK COLLECT INTO l_pb_gl_jrad_docs_tbl
275: FROM cz_ui_templates t0
276: WHERE t0.seeded_flag = '0'
277: AND t0.ui_def_id = 1
278: AND NOT EXISTS (SELECT 1 FROM cz_model_publications
279: WHERE object_type = 'UIT'
280: AND deleted_flag = '0'
281: AND ui_def_id = 1
282: AND source_target_flag = 'T'

Line 287: AND EXISTS (SELECT 1 FROM cz_model_publications

283: AND object_id = t0.template_id)
284: AND NOT EXISTS (SELECT 1 FROM cz_ui_templates t
285: WHERE t.seeded_flag = '0'
286: AND t.ui_def_id = 1
287: AND EXISTS (SELECT 1 FROM cz_model_publications
288: WHERE object_type = 'UIT'
289: AND deleted_flag = '0'
290: AND ui_def_id = 1
291: AND source_target_flag = 'T'