APPS.CZ_MODEL_CONVERT dependencies on CZ_MODEL_REF_EXPLS

Line 924: 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';

920: v_cz_expression_nodes(v_cz_expr_node_count).mutable_flag := '1';
921: -- v_cz_expression_nodes(v_cz_expr_node_count).source_offset := 15;
922: -- v_cz_expression_nodes(v_cz_expr_node_count).source_length := 24;
923:
924: 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';
925: v_cz_expression_nodes(v_cz_expr_node_count).model_ref_expl_id := l_mod_ref;
926:
927: --Mark the rule as a default rule
928: populate_cz_tables(true);

Line 1010: 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) ;

1006: v_cz_expr_node_count:=v_cz_expr_node_count+1;
1007:
1008: IF p_model_ref_expl_id IS NULL THEN
1009: l_ps_node_id :=ps_node_id;
1010: 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) ;
1011: ELSE
1012: l_mod_ref:=p_model_ref_expl_id; -- use model_ref_expl_id from parent contribute / consume rule .
1013: END IF;
1014:

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

2207:
2208: retcode:=0;
2209: cz_pb_mgr.GLOBAL_EXPORT_RETCODE := 0;
2210:
2211: FOR c_pub IN (SELECT publication_id ,max(node_depth) mdepth FROM cz_model_publications mp ,cz_model_ref_expls mr
2212: WHERE mp.migration_group_id = p_request_id AND mp.deleted_flag = '0' and mr.deleted_flag = '0'
2213: AND mp.publication_mode='M'
2214: and mr.model_id =mp.object_id
2215: group by publication_id