APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on QA_RESULTS

Line 567: SELECT plan_id FROM qa_results

563: AND ATA.lookup_code (+) = MCR.ata_code
564: AND ATA.lookup_type (+) = 'AHL_ATA_CODE';
565:
566: CURSOR get_paln_id (c_collection_id NUMBER) IS
567: SELECT plan_id FROM qa_results
568: WHERE collection_id = c_collection_id;
569:
570: CURSOR get_csi_ii_details (c_instance_id NUMBER) IS
571: SELECT relationship_id,object_version_number