[Home] [Help]
325: END IF;
326:
327: BEGIN
328: select qp.name into l_plan_name
329: from qa_plans qp,
330: qa_results qr
331: where
332: qr.collection_id = l_collection_id
333: and
930:
931:
932: CURSOR get_plan_name(qa_collection_id IN NUMBER) IS
933: (select qp.name
934: from qa_plans qp,
935: qa_results qr
936: where
937: qr.collection_id = qa_collection_id
938: and