APPS.CZ_MODEL_CONVERT dependencies on CZ_MODEL_REF_EXPLS

Line 918: SELECT MIN(MODEL_REF_EXPL_ID) INTO l_mod_ref FROM cz_model_ref_expls WHERE model_id=dev_project_id AND deleted_flag='0';

914: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := '1';
915: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 15;
916: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 24;
917:
918: SELECT MIN(MODEL_REF_EXPL_ID) INTO l_mod_ref FROM cz_model_ref_expls WHERE model_id=dev_project_id AND deleted_flag='0';
919: v_cz_expression_nodes(v_cz_expr_node_count).model_ref_expl_id := l_mod_ref;
920:
921: --Mark the rule as a default rule
922: populate_cz_tables(true);

Line 1004: SELECT MIN(MODEL_REF_EXPL_ID) INTO l_mod_ref FROM cz_model_ref_expls WHERE model_id=dev_project_id AND deleted_flag='0' AND component_id=(select component_id from cz_ps_nodes ps where ps.ps_node_id=l_ps_node_id) ;

1000: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1001:
1002: IF p_model_ref_expl_id IS NULL THEN
1003: l_ps_node_id :=ps_node_id;
1004: SELECT MIN(MODEL_REF_EXPL_ID) INTO l_mod_ref FROM cz_model_ref_expls WHERE model_id=dev_project_id AND deleted_flag='0' AND component_id=(select component_id from cz_ps_nodes ps where ps.ps_node_id=l_ps_node_id) ;
1005: ELSE
1006: l_mod_ref:=p_model_ref_expl_id; -- use model_ref_expl_id from parent contribute / consume rule .
1007: END IF;
1008:

Line 2179: FOR c_pub IN (SELECT publication_id ,max(node_depth) mdepth FROM cz_model_publications mp ,cz_model_ref_expls mr

2175:
2176: retcode:=0;
2177: cz_pb_mgr.GLOBAL_EXPORT_RETCODE := 0;
2178:
2179: FOR c_pub IN (SELECT publication_id ,max(node_depth) mdepth FROM cz_model_publications mp ,cz_model_ref_expls mr
2180: WHERE mp.migration_group_id = p_request_id AND mp.deleted_flag = '0' and mr.deleted_flag = '0'
2181: AND mp.publication_mode='M'
2182: and mr.model_id =mp.object_id
2183: group by publication_id