APPS.CZ_IMP_SINGLE dependencies on CZ_MODEL_REF_EXPLS

Line 3806: FOR model IN (SELECT DISTINCT component_id FROM cz_model_ref_expls WHERE model_id = nModelId

3802: end if;
3803:
3804: ----2) Populate the table for UI refresh using the extracted list of models
3805:
3806: FOR model IN (SELECT DISTINCT component_id FROM cz_model_ref_expls WHERE model_id = nModelId
3807: AND deleted_flag = '0' AND (ps_node_type IN (263, 264) OR parent_expl_node_id IS NULL))LOOP
3808:
3809: FOR j IN (SELECT devl_project_id FROM cz_devl_projects
3810: WHERE devl_project_id = model.component_id AND deleted_flag='0')

Line 3883: --Populate has_trackable_children flag in cz_model_ref_expls. It is sufficient to call the procedure

3879: END;
3880: END LOOP;
3881: CLOSE C_IMPORT_ORDER;
3882:
3883: --Populate has_trackable_children flag in cz_model_ref_expls. It is sufficient to call the procedure
3884: --only once for the very root project. For every run_id there is exactly one record in the table for
3885: --the root project (this is not necessarily true for the child models).
3886: BEGIN
3887: SELECT model_ps_node_id INTO nModelId