APPS.QA_SEQUENCE_API dependencies on QA_PC_RESULTS_RELATIONSHIP

Line 428: NOT EXISTS (SELECT 1 FROM qa_pc_results_relationship qprr

424: CURSOR all_plan_cur IS
425: SELECT distinct qr.plan_id
426: FROM qa_results qr
427: WHERE qr.collection_id = p_collection_id AND
428: NOT EXISTS (SELECT 1 FROM qa_pc_results_relationship qprr
429: WHERE qprr.child_plan_id = qr.plan_id AND
430: qprr.child_collection_id = qr.collection_id AND
431: qprr.child_occurrence = qr.occurrence);
432:

Line 718: FROM qa_pc_results_relationship r

714: parent_plan_id,
715: parent_collection_id,
716: parent_occurrence,
717: level levels
718: FROM qa_pc_results_relationship r
719: START WITH r.parent_plan_id = p_plan_id AND
720: r.parent_collection_id = p_collection_id
721: CONNECT BY PRIOR r.child_occurrence = r.parent_occurrence
722: ORDER BY levels, parent_occurrence, child_occurrence;

Line 734: -- qa_pc_results_relationship_v. rponnusa Thu Dec 18 21:28:55 PST 2003

730: -- bso Tue Mar 28 12:59:39 PST 2006
731: --
732:
733: -- Bug 3283794. Modified dde_cur to select from
734: -- qa_pc_results_relationship_v. rponnusa Thu Dec 18 21:28:55 PST 2003
735:
736: /* CURSOR dde_cur IS
737: SELECT 0 child_plan_id,
738: 0 child_collection_id,

Line 755: FROM qa_pc_results_relationship_v r

751: parent_plan_id,
752: parent_collection_id,
753: parent_occurrence,
754: level levels
755: FROM qa_pc_results_relationship_v r
756: WHERE r.child_txn_header_id = p_txn_header_id
757: START WITH r.parent_plan_id = p_plan_id
758: CONNECT BY PRIOR r.child_occurrence = r.parent_occurrence
759: ORDER BY levels; */

Line 762: -- To make it compatible removed the call to view qa_pc_results_relationship_v

758: CONNECT BY PRIOR r.child_occurrence = r.parent_occurrence
759: ORDER BY levels; */
760:
761: -- Bug 3578477. Above commented CURSOR is not compatible with Oracle 8i
762: -- To make it compatible removed the call to view qa_pc_results_relationship_v
763: -- and replaced it with qa_pc_results_relationship table and changed the
764: -- where condition of second select query.
765: -- saugupta Tue, 20 Apr 2004 04:09:30 -0700 PDT
766:

Line 763: -- and replaced it with qa_pc_results_relationship table and changed the

759: ORDER BY levels; */
760:
761: -- Bug 3578477. Above commented CURSOR is not compatible with Oracle 8i
762: -- To make it compatible removed the call to view qa_pc_results_relationship_v
763: -- and replaced it with qa_pc_results_relationship table and changed the
764: -- where condition of second select query.
765: -- saugupta Tue, 20 Apr 2004 04:09:30 -0700 PDT
766:
767: --

Line 796: FROM qa_pc_results_relationship r

792: parent_plan_id,
793: parent_collection_id,
794: parent_occurrence,
795: level levels
796: FROM qa_pc_results_relationship r
797: WHERE p_txn_header_id =
798: (SELECT qr.txn_header_id
799: FROM qa_results qr
800: WHERE qr.plan_id = r.child_plan_id and

Line 839: FROM qa_pc_results_relationship r

835: parent_plan_id,
836: parent_collection_id,
837: parent_occurrence,
838: level levels
839: FROM qa_pc_results_relationship r
840: START WITH --r.parent_plan_id = p_plan_id AND
841: r.child_txn_header_id = p_txn_header_id
842: CONNECT BY PRIOR r.child_occurrence = r.parent_occurrence
843: ORDER BY levels, parent_occurrence, child_occurrence;

Line 2534: FROM qa_pc_results_relationship r

2530: CURSOR enabled_child_cur IS
2531: SELECT child_plan_id, child_collection_id, child_occurrence,
2532: parent_plan_id, parent_collection_id, parent_occurrence,
2533: level
2534: FROM qa_pc_results_relationship r
2535: WHERE EXISTS (
2536: SELECT 1
2537: FROM qa_results qr
2538: WHERE qr.plan_id = r.child_plan_id AND

Line 2837: FROM qa_pc_results_relationship qprr

2833: FROM qa_results qr
2834: WHERE qr.collection_id = p_collection_id
2835: AND NOT EXISTS
2836: (SELECT 1
2837: FROM qa_pc_results_relationship qprr
2838: WHERE qprr.child_plan_id = qr.plan_id
2839: AND qprr.child_collection_id = qr.collection_id
2840: AND qprr.child_occurrence = qr.occurrence);
2841: