APPS.QA_ERES_UTIL dependencies on QA_PC_RESULTS_RELATIONSHIP

Line 18: FROM qa_pc_results_relationship qprr

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:

Line 377: FROM qa_pc_results_relationship

373: CURSOR c(coll_id IN varchar2) is SELECT distinct plan_id
374: FROM qa_results
375: WHERE plan_id || '-' || collection_id || '-' || occurrence NOT IN
376: (SELECT child_plan_id || '-' || child_collection_id || '-' || child_occurrence
377: FROM qa_pc_results_relationship
378: WHERE parent_collection_id = coll_id)
379: AND collection_id = coll_id;
380:
381: BEGIN