APPS.CZ_IMP_PS_NODE dependencies on CZ_MODEL_REF_EXPLS

Line 1064: SELECT d.devl_project_id, e.model_ref_expl_id FROM cz_devl_projects d, cz_model_ref_expls e

1060: SELECT NULL FROM cz_devl_projects
1061: WHERE devl_project_id = REFRESH_MODEL_ID
1062: AND deleted_flag = '0';
1063: CURSOR c_onl_model_id IS
1064: SELECT d.devl_project_id, e.model_ref_expl_id FROM cz_devl_projects d, cz_model_ref_expls e
1065: WHERE d.deleted_flag = '0'
1066: AND e.deleted_flag = '0'
1067: AND d.orig_sys_ref = sOrigSysRef
1068: AND e.model_id = REFRESH_MODEL_ID

Line 1824: --DELETE FROM cz_model_ref_expls WHERE model_id = p_xfr_devl_project.devl_project_id

1820: --child models. However, this brings in problems when refreshing BOM models with
1821: --eventually created rules. As the functionality of creating new copies of child models
1822: --is frozen, we can go without this thus not having problems refreshing with rules.
1823:
1824: --DELETE FROM cz_model_ref_expls WHERE model_id = p_xfr_devl_project.devl_project_id
1825: --AND parent_expl_node_id IS NOT NULL;
1826:
1827: EXCEPTION
1828: WHEN OTHERS THEN