APPS.QA_SKIPLOT_RCV_GRP dependencies on QA_RESULTS

Line 597: FROM qa_results qr

593:
594: --uses qa_pc_results_relationship to ensure we don't count orphan child rows
595: CURSOR C1 IS
596: SELECT count(qr.occurrence)
597: FROM qa_results qr
598: WHERE qr.collection_id = p_collection_id
599: AND qr.occurrence NOT IN (SELECT qprr.child_occurrence
600: FROM qa_pc_results_relationship qprr);
601: l_res_count NUMBER := 0;

Line 634: -- do a lookup on qa_results to check for the collection_id

630: x_return_status := fnd_api.g_ret_sts_success;
631: x_result_present := fnd_api.g_false;
632:
633: --
634: -- do a lookup on qa_results to check for the collection_id
635: -- in a non-child plan
636: --
637: OPEN C1;
638: FETCH C1 INTO l_res_count;