178: SELECT
179: distinct(prereq_bug_number) prereq_bug_num ,
180: prereq_bug_order
181: FROM
182: ad_pa_anal_bug_deps
183: WHERE
184: analysis_run_id = X_anal_req_id and
185: bug_number = X_bug_number
186: order by prereq_bug_order;
244: CURSOR prereq_cur(X_anal_req_id Number , X_bug_number Number) IS
245: SELECT
246: distinct(prereq_bug_number) prereq_bug_num ,
247: prereq_bug_order
248: FROM ad_pa_anal_bug_deps
249: WHERE analysis_run_id = X_anal_req_id AND
250: bug_number = X_bug_number
251: ORDER BY prereq_bug_order;
252: