1540: )
1541: AND cz_rules.devl_project_id = p_dev_project_id
1542: UNION ALL
1543: SELECT DISTINCT cf.rule_id ,ps.devl_project_id
1544: FROM cz_des_chart_features cf,
1545: cz_des_chart_features cf1,
1546: cz_ps_nodes ps,
1547: cz_ps_nodes ps1,
1548: cz_rules rule
1541: AND cz_rules.devl_project_id = p_dev_project_id
1542: UNION ALL
1543: SELECT DISTINCT cf.rule_id ,ps.devl_project_id
1544: FROM cz_des_chart_features cf,
1545: cz_des_chart_features cf1,
1546: cz_ps_nodes ps,
1547: cz_ps_nodes ps1,
1548: cz_rules rule
1549: WHERE cf.rule_id = cf1.rule_id
1594: )
1595: AND cz_rules.devl_project_id = p_dev_project_id
1596: UNION ALL
1597: SELECT DISTINCT cf.rule_id ,ps.devl_project_id
1598: FROM cz_des_chart_features cf,
1599: cz_des_chart_features cf1,
1600: cz_ps_nodes ps,
1601: cz_ps_nodes ps1,
1602: cz_rules rule
1595: AND cz_rules.devl_project_id = p_dev_project_id
1596: UNION ALL
1597: SELECT DISTINCT cf.rule_id ,ps.devl_project_id
1598: FROM cz_des_chart_features cf,
1599: cz_des_chart_features cf1,
1600: cz_ps_nodes ps,
1601: cz_ps_nodes ps1,
1602: cz_rules rule
1603: WHERE cf.rule_id = cf1.rule_id