3293: WHERE plan_id = p_plan_id;
3294:
3295: CURSOR valueLookups(c_char_id NUMBER) IS
3296: SELECT short_code
3297: FROM qa_plan_char_value_lookups
3298: WHERE plan_id = p_plan_id
3299: AND char_id = c_char_id;
3300:
3301: l_template_plan_id NUMBER;
3298: WHERE plan_id = p_plan_id
3299: AND char_id = c_char_id;
3300:
3301: l_template_plan_id NUMBER;
3302: l_short_code qa_plan_char_value_lookups.short_code%TYPE;
3303: BEGIN
3304: OPEN plan;
3305: FETCH plan INTO l_template_plan_id;
3306: CLOSE plan;