APPS.CZ_IMP_SINGLE dependencies on CZ_MODEL_REF_EXPLS

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

4152: end if;
4153:
4154: ----2) Populate the table for UI refresh using the extracted list of models
4155:
4156: FOR model IN (SELECT DISTINCT component_id FROM cz_model_ref_expls WHERE model_id = nModelId
4157: AND deleted_flag = '0' AND (ps_node_type IN (263, 264) OR parent_expl_node_id IS NULL))LOOP
4158:
4159: FOR j IN (SELECT devl_project_id FROM cz_devl_projects
4160: WHERE devl_project_id = model.component_id AND deleted_flag='0')

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

4229: END;
4230: END LOOP;
4231: CLOSE C_IMPORT_ORDER;
4232:
4233: --Populate has_trackable_children flag in cz_model_ref_expls. It is sufficient to call the procedure
4234: --only once for the very root project. For every run_id there is exactly one record in the table for
4235: --the root project (this is not necessarily true for the child models).
4236: BEGIN
4237: SELECT model_ps_node_id INTO nModelId

Line 4270: (SELECT DISTINCT component_id FROM cz_model_ref_expls

4266: AND MODEL.deleted_flag = '0'
4267: AND PARENT.devl_project_id = MODEL.object_id
4268: AND MODEL.object_type = 'PRJ'
4269: AND parent.devl_project_id IN
4270: (SELECT DISTINCT component_id FROM cz_model_ref_expls
4271: WHERE deleted_flag = '0' AND model_id = nModelId
4272: AND (ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE
4273: OR ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_MODEL))
4274: AND PARENT.ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS