Line 5297: SELECT COUNT(*) INTO l_failure_flag FROM CZ_DB_LOGS WHERE run_id=l_cp_rule_run_id;
5293: END IF;
5294:
5295: l_failure_flag := 0;
5296: IF l_cp_rule_run_id > 0 THEN 5297: SELECT COUNT(*) INTO l_failure_flag FROM CZ_DB_LOGS WHERE run_id=l_cp_rule_run_id; 5298: END IF;
5299:
5300: IF l_failure_flag=0 AND NVL(k.devl_project_id,0) NOT IN(0,1) AND l_copied_rule THEN
5301: CZ_DEVELOPER_UTILS_PVT.verify_special_rule(p_rule_id => x_rule_id,