DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on QA_PLANS

Line 12003: from qa_results qr,qa_plans qp

11999: l_asset_ops_return_status VARCHAR2(1);
12000: begin
12001:
12002: select qp.plan_id,name bulk collect into l_plan_id_tbl,l_plan_name_tbl
12003: from qa_results qr,qa_plans qp
12004: where qr.plan_id = qp.plan_id
12005: and collection_id = l_eam_wo_comp_rec.qa_collection_id;
12006:
12007: IF l_plan_id_tbl.COUNT > 0 THEN