APPS.CZ_IMP_PS_NODE dependencies on CZ_MODEL_REF_EXPLS

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

860: SELECT NULL FROM cz_devl_projects
861: WHERE devl_project_id = REFRESH_MODEL_ID
862: AND deleted_flag = '0';
863: CURSOR c_onl_model_id IS
864: SELECT d.devl_project_id, e.model_ref_expl_id FROM cz_devl_projects d, cz_model_ref_expls e
865: WHERE d.deleted_flag = '0'
866: AND e.deleted_flag = '0'
867: AND d.orig_sys_ref = sOrigSysRef
868: AND e.model_id = REFRESH_MODEL_ID

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

1571: --child models. However, this brings in problems when refreshing BOM models with
1572: --eventually created rules. As the functionality of creating new copies of child models
1573: --is frozen, we can go without this thus not having problems refreshing with rules.
1574:
1575: --DELETE FROM cz_model_ref_expls WHERE model_id = p_xfr_devl_project.devl_project_id
1576: --AND parent_expl_node_id IS NOT NULL;
1577:
1578: EXCEPTION
1579: WHEN OTHERS THEN