13: ARGUMENT2 IN NUMBER) IS
14:
15: CURSOR c (p_plan_name VARCHAR2) IS
16: SELECT plan_id 17: FROM qa_plans 18: WHERE name = p_plan_name;
19:
20: CURSOR c2 (p_org_id NUMBER) IS
21: SELECT plan_id
Line 22: FROM qa_plans
18: WHERE name = p_plan_name;
19:
20: CURSOR c2 (p_org_id NUMBER) IS
21: SELECT plan_id 22: FROM qa_plans 23: WHERE organization_id = p_org_id;
24:
25: l_plan_id NUMBER;
26: