[Home] [Help]
2051: SELECT 1 INTO l_count
2052: FROM DUAL
2053: WHERE EXISTS
2054: ( SELECT null
2055: FROM PA_FORECAST_ITEMS
2056: WHERE project_id = l_fp_cols_rec_tgt.X_PROJECT_ID
2057: AND error_flag = 'Y' );
2058: EXCEPTION
2059: WHEN NO_DATA_FOUND THEN