DBA Data[Home] [Help]

APPS.QA_SSQR_JRAD_PKG dependencies on QA_PLAN_CHAR_VALUE_LOOKUPS

Line 3297: FROM qa_plan_char_value_lookups

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;

Line 3302: l_short_code qa_plan_char_value_lookups.short_code%TYPE;

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;