DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on QA_PLANS

Line 12400: from qa_results qr,qa_plans qp

12396: BEGIN
12397:
12398: select qp.plan_id,name bulk collect
12399: into l_plan_id_tbl,l_plan_name_tbl
12400: from qa_results qr,qa_plans qp
12401: where qr.plan_id = qp.plan_id
12402: and collection_id = l_eam_wo_comp_rec.qa_collection_id;
12403:
12404: END;

Line 12655: from qa_results qr,qa_plans qp

12651: begin
12652: --BUG12914431. commented below code and moved it above
12653: /*
12654: select qp.plan_id,name bulk collect into l_plan_id_tbl,l_plan_name_tbl
12655: from qa_results qr,qa_plans qp
12656: where qr.plan_id = qp.plan_id
12657: and collection_id = l_eam_wo_comp_rec.qa_collection_id;
12658: */
12659: IF l_plan_id_tbl.COUNT > 0 THEN