14:
15:
16: CURSOR C1 (l_occ NUMBER) IS
17: SELECT parent_occurrence, parent_collection_id, parent_plan_id
18: FROM qa_pc_results_relationship qprr
19: CONNECT BY prior qprr.parent_occurrence = qprr.child_occurrence
20: START WITH qprr.child_occurrence = l_occ
21: ORDER BY level desc;
22:
388: CURSOR c(coll_id IN varchar2) is SELECT distinct plan_id
389: FROM qa_results
390: WHERE plan_id || '-' || collection_id || '-' || occurrence NOT IN
391: (SELECT child_plan_id || '-' || child_collection_id || '-' || child_occurrence
392: FROM qa_pc_results_relationship
393: WHERE parent_collection_id = coll_id)
394: AND collection_id = coll_id;
395:
396: BEGIN